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

Only if you store the values of Column E and then compare the appropriate
value to the current value.

--
Regards,
Tom Ogilvy

"Rasmus" wrote in message
t.cable.rogers.com...
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