VBA Detect Paste

[crspycrtr]

I have a worksheet that automatically clears the cells in the columns to the right of the changed cell. The problem is that if I copy and paste the row above and paste it to several rows below, the first pasted row has the data to the right cleared all of the other rows are fine. I need to be able to recognize when someone is pasting so I can exit the macro.

 

[Tom Urtis]

Post your code so a better understanding can be had about what you are doing programmatically, and how the action can be bypassed for paste based on the logic you are using to trigger the (presumably) Change event.

 

[Tim_Myth]

I think I understand his question because it sounds similar to the issue for which I was searching for a solution. My solution was to place a sub in the ThisWorkbook module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
   If Target.Count > 1 Then
      MsgBox("You just pasted " & Target.Count & " cells of data into sheet " & Sh.Name & "!")
   End If
End Sub