How do I determine the Range that was pasted
 

Thanks to both Jim and Gary's Student. Both of your suggestions are what I'm
looking for.

thanks,
mike

"Mike" wrote in message
...
I want to detect the cells that change on a worksheet as a result of a
manual copy. For example, I manually select the Range("F16:G26") on some
other sheet in another Workbook, copy that range, and then click a cell in
the active sheet and paste it.

Using the function below I can determine the cell that was clicked and
changed, but, how do I determine the range of cells that were changed.



Private Sub Worksheet_Change(ByVal Target As Range)

Dim aa, cc, rr

aa = Target

cc = Target.Column

rr = Target.row

End Sub