Hi Gurus
Have 7 Macros waiting to run "Application.OnTime TimeValue(Range("$X$9").Text), "WebPull"
Sometimes they run
Sometimes they don't
Looking on the Net came across
"if meanwhile another procedure is being executed and Excel is not in ready mode within 20 seconds, this procedure will not run."
"This means that the time when the procedure is to run (EarliestTime argument) should be assigned to a variable"
Trouble is me not know how to set up variables
Any assistance greatly appreciated as always you da men
Mike : )
Sub settimers()
Call WebPullOne 'Initial 1st Call
Call Macro58 'Light Says Go and Stop at set time has been pushed
Application.OnTime TimeValue(Range("$X$9").Text), "StartBlink" ' When Webpull starts
Application.OnTime TimeValue(Range("$x$10").Text), "OneOne" ' Start
Application.OnTime TimeValue(Range("$Z$11").Text), "JR_Cell_B10_Test_Run" ' Start
Application.OnTime TimeValue(Range("$Z$12").Text), "JR_Cell_B10_Test_Run2" ' Start
Application.OnTime TimeValue(Range("$X$3").Text), "OffEditQuery" 'EveryThing
Application.OnTime TimeValue(Range("$X$9").Text), "WebPull" ' Main Set to 1 Min refreshes
Application.OnTime TimeValue(Range("$W$11").Text), "StopBlink" 'When Webpull stops
Call Recalc 'Starts Count own Clock
End Sub
Bookmarks