View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
APS APS is offline
external usenet poster
 
Posts: 5
Default 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.