Hi,
I have put together the following macro to run when a countdown timer is between a certain range. I only want it to run the Capture macro once.
Is this a good way to code it or can anyone see any potential issues?
Thanks
I have put together the following macro to run when a countdown timer is between a certain range. I only want it to run the Capture macro once.
Is this a good way to code it or can anyone see any potential issues?
VBA Code:
Private Sub Worksheet_Calculate()
Application.EnableEvents = False
If Range("AG5") < 12650 And Range("AG5") > 12640 Then Call Capture
Application.EnableEvents = True
End Sub
Thanks