Get a cell's previous value

R

Rick

Is there a cell (or range) property that can be used to get the previous value of a cell? I would
like to run an if statement based on whether the new value is greater than or less than the old value

Thanks,

Rick
 
V

Vasant Nanavati

No. You would have to write code to "remember" the value of the currently
active cell in a global variable.
 
Top