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

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