Running a macro by changing a cell value
 

Foiled by Delete!

I use the following code to run a macro called "UpdateE5" whenever cell E4
is edited.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E4")) Is Nothing Then
If Range("E4").Value < gOldE4 Then
gOldE4 = Range("E4").Value
Application.Run "UpdateE5"
End If
End If
End Sub

It works for any change in cell E4 except when that change is brought about
by the use of the Delete key.
ie, select cell E4, hit Delete, and pooh! Nothing!
Is this possible to overcome?
Regards - Dave B.

Running a macro by changing a cell value
 

What version are you using? Works for me....XL2002SP3 & XP

Why not use
If Target.Address instead of Intersect?

OJ