Need A Way To Track How Many Times A Macro Has Been Run On A Sheet

[aedctalk]

Hi!

I'm looking for some help coding the following:

I have a sheet with a "Close Shift" macro..

let the below be the default

a1 = 1


Now after i click close shift macro i'd like for it to be

value of a1 is now 2


is this possible?

how could i go about doing it? Thank you!!

 

[Ralajer]

Yes it is possible. Add the following line to the macro you want to track.

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

Probably best to throw it at the beginning of the macro

Sub CloseShift()
     '// Tracks the number of time the macro has run.
    Range("A1").Value = Range("A1").Value + 1 
    '// Macro Code
    '...
End Sub

 

[aedctalk]

Thank you very much. wow such a simple code! works wonderful