Variable type for Application on Time Events [on hold]
- by user2931226
Been Trying to figure out how to go about setting a Variable for some Application On Time events, But still not confident to do it.
These events (Macro's) get called by another Macro then they wait for 10 - 20 minutes, then they don't Run.
So have read that (EarliestTime argument) should be assigned to a variable to store it other wise it looses it when other things are running
Help appreciated Thanks
Sub settimers()
Application.OnTime TimeValue(Range("$X$9").Text), "StartBlink"
Application.OnTime TimeValue(Range("$W$11").Text), "StopBlink"
End Sub