Get a cell's previous value

  • Thread starter Thread starter Rick
  • Start date Start date
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
 
No. You would have to write code to "remember" the value of the currently
active cell in a global variable.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Conditional format if difference in cell values greater than 0.50% 1
Comparing Values from One Cell to Another 1
Color cell depending on it's previous value 4
Code to Concat a row in loop 2
Change_Event troubles, no error & no work. 6
Macro to check if current cell value is 1 and previous cell was 0 6
Run Macro If Cell have "x" value 0

Back
Top