Using the Worksheet_Change event like this:
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address(0, 0)
End Sub
Produces the row number of the row that was deleted. For instance, if you
delete row 5, the MsgBox will display "5:5" without the quotes. This works
whether or not the row was a blank row. Does that help? HTH Otto
"Tim Patton" wrote in message
...
In the worksheet_change event, I'm trying to determine if a row has been
deleted. Is there a way to determine what event occurred?