Disabling worksheet_change when deleting rows . .
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!
|