I want to be able to capture / record aging... but also, stop the counter once I record a completion date in a given field...

This is what I have, so far:


This is giving me what I need, as I am able to keep the counter going...

However, once I have a completion date in place... I want to stop the counter...

Any thoughts~




You can do what is called copy/paste special to freeze it.

  1. Select the cell.
  2. Hit Ctrl + C
  3. Hit Alt + E + S + V
  4. Hit Enter

Or you could use a simple macro like this:

Freeze the date/value of the selected cell.

Sub freeze_value_1()

Selection.Value = Selection.Value

End Sub

Freeze the date/value of a specific cell.

Sub freeze_value_2()

Range("A1").Value = Range("A1").Value

End Sub

In the last macro, replace A1 with the cell that has the date that you want to stop or freeze.


Answer the Question

You must create an account to use the forum. Create an Account or Login