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
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