Get a cell's previous value
 

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

Get a cell's previous value
 

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

--

Vasant


"Rick" wrote in message
news:oMVgc.161569$gA5.1904040@attbi_s03...
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