title: Is there an excel VBA line of code I can add to check if any values in a column have changed since the last time the macro was ran?
body: <p>I have a main work area. This main work area is setup with so that a bunch of different sections can be shown or not shown in the main area based on checkboxes. We run a Macro (via a button) every time we are ready to send the clients updates. I want to add in our main macro a prompt/warning to pop up ONLY IF someone has changed the checkboxes. I have a column the boxes are tied to with "TRUE"/"FALSE" values. </p>
  
  <p>Can i set the range for my column say  $V:$10:$V:$90 so that if any of those values are not the same as they were the last time this macro was ran, it will prompt the user?</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Edit: Alternatively, there are several sheets in this workbook. I could essentially copy/paste the column range i want to a new area, and then compare the two columns everytime the macro is ran. If they are not the same, then pop up a message box. But I am hoping there is a way to just analyze the data. </p>
  
  <p>Thanks</p>