I have the following sub to determine whether another sub should be run:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Range("e" & Target.Row) < "" Then
MsgBox ("This line qualifies for the sub!")
' Call the sub
End If
End Sub

Is there a way to only run the sub if target is CHANGED from 0 to something
that 0 ?

Rasmus