My suggestion was that if "Target" is a full row then don't do anything.

If Target.Columns.Count=256 and Target.Rows.Count=1 then
'do nothing
else
'event
End If

....but since I'm not sure waht you're trying to track with the change event
I can't know if that would work for you. Either deleting or inserting a row
would hit the "do nothing"

Tim.

wrote in message
oups.com...
Hmm . . Can't see how I can make that work.

I will elaborate on the problem. Here's what I need to do.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("W:W")) Is Nothing Then
If Application.CutCopyMode = 0 Then
If <* Condition to check row deletes * = 0 Then
<< Event
End If
End If
End If

I need to know how to write the <* Condition to check row deletes *
If a row is being deleted then don't trigger the event.

Thanks!