Target, an argument in the worksheet_Change event holds a reference to what
has changed.

Right click on the sheet tab and select view code. Put in code like this:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Then play around with your sheet.

--
Regards,
Tom Ogilvy






"TimD" wrote in message
...
I am using the Worksheet_Change event to manipulate data on a sheet.

Can I capture the event that has caused a change to the worksheet. Like
the
difference between deleting an entire row and deleting a specified range.