In Access there is a property called OldValue. It holds onto the value when
a field is changed. What I am looking for is something similar in Excel.

I've written a Worksheet_Change event which will look for a value entered
into a cell within a certain specified range to make sure the value hasn't
already been entered elsewhere in the range. The only thing I need is a way
to retain the OldValue in case I need to recall the value and nullify the
change.

Ideas?

Thanks