View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] makkarm@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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!