I am trying to write a function in Excel(97) that when a user enters a value into a cell it compares the new value that has been entered and the old value of the cell, and returns the difference between these 2 values.
I realise that I could do this by using to different cells but unfortunately this is not feasible.
I struggling with this though as I can't seem to find a way of getting the old value of the cell. Anyone got any ideas as to how I'd do this. The only thing I can think of at the moment is storing the new value, undoing the change and storing the old value then redoing the change.
Any help gratefully appreciated
Waud
I realise that I could do this by using to different cells but unfortunately this is not feasible.
I struggling with this though as I can't seem to find a way of getting the old value of the cell. Anyone got any ideas as to how I'd do this. The only thing I can think of at the moment is storing the new value, undoing the change and storing the old value then redoing the change.
Any help gratefully appreciated
Waud