I'm not sure how you can find out if the row was deleted, but you could do this
if you want to ignore any changes that are done to complete rows.

If Target.Address = Target.EntireRow.Address Then
Exit Sub
End If



pd1234321 wrote:

Hello,

I am using the Worksheet_Change function above to record the time a user
makes a change to the worksheet. It is working great, except that I don't
want to record the change if the user deletes the entire row (selects the
entire row and hits CTRL-). The reason I don't want to record this change is
that it actually records the date of the change on the next row, which
actually didn't change.

I am using a little If Then statement in the beginning of the routine to
skip past the change code when I use another module to load information into
the worksheet. That works fine, but I don't know how to handle the issue
above.

First time poster. I would really appreciate any help.

Thank you.

--

Dave Peterson