Run a Macro if cell value is greater than 1 but not empty

[Vokesie]

Evening all,

I am after a bit of simple help.

I want to run a macro when a cell with in a range such as A3:A500 changes from empty to a value. but not the other way i.e clearing the cell of data.

I have tried using various Worksheet_Change(ByVal Target As Range) methods but it Is still running a macro when I clear the cell.


thanks in advance

V

 

[Eric W]

You could add a line like:

If Target.Value = "" Then Exit Sub

within your change event.

 

[Vokesie]

Thank you I will give it a go and let you know

Thanks