Getting pre edit values
I am using Worksheet_Change to identify edits on a sheet and highlight the
changes where appropriate by testing on the Target object.
What I really need is to be able to retrieve the value of the cell before
the edit is done, i.e. if the cell is changed from 2 to 3 I need to retieve
the value 2.
Is this possible??
Tnanks in advance for any help on this.
|