Trapping Copy To Range Before Copy/Cut Paste

[Excel Fox]

You could identify the range that is being selected after the user has copied a range by using the following code in the respective sheet module (here sheet is where the user is selecting the cells to paste)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Application.CutCopyMode <> False Then
        MsgBox Target.Address
    End If
    
End Sub

[Rasm]

Thanks - I will try that - Right now I use the selectionchange in the workbook - so looks like I can use the code there as well - I check it out

[Rasm]

ahhh - as it turns out - I can trap the paste part like this - so your code Kris - I can use to trap the copy part.

So now I can trap both events - hehehee - I do it all in ThisWorkbook - but that makes no real diff

Anyway - Now that I know how to trap both mouse actions - I can move forward

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
    ActiveSheet.Label1.Caption = "Right click=" & Target.Address
End Sub