Count sheet refresh

[elviajero]

I have a workbook with VBA code that automatically refreshes the workbook every second. I start and stop the auto refresh with a macro.

I'm looking for a way to count (+1) every time the refresh happens.

Anyone have anyway of doing this?

 

[revcanon]

The issue I see is that each time the code is run the count value resets to "Empty".
You could set a cell somewhere out of the way with a Value of 0

Then within you counting code after it refreshes:

i = Range("A1").Value 'whatever cell reference you want to use
i = i + 1 'adds 1
Range("A1").Value = i 'changes cell value for next count

Your cell would contain the value of the number of refreshes, and the number wouldn't reset after each subsequent run.

Unfortunately, the number in that cell will grow sequentially and never reset to 0 unless you do it manually.

Someone else may be able to give you more help if you need something further.