title: How to get snapshot of current time in VBA?
body: <p>In my VBA code, I am updating cells with either <code>Cell.Value = Now</code> or <code>Cell.Value = Format(Now, "hh:mm:ss")</code>.</p>
  
  <p>I am doing this for four different cells. However, I notice that when one of the cells change, the rest of the timestamps change to reflect the current time. To me it seems that these cells are just a reference to the latest time, and not a snapshot of when the cell was updated.</p>
  
  <p>Is there anyway to take a snapshot of the time so that it won't change on a sheet refresh?</p>