Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am testing a simple OnTime procedure and receive an error 1004 upon
execution. Entire code is: Sub SetAlarm() Application.OnTime TimeValue("10:35:00 am"), "RunTest" End Sub Sub RunTest() Range("A50").End(xlUp).Offset(1, 0).Value = Date End Sub Sub SetAnotherAlarm() Application.OnTime EarliestTime:=TimeValue("10:48:00 am"), Procedu="RunTest", Schedule:=False End Sub The first OnTime procedure runs fine, but when I add the optional "Schedule", I get an error "Method OnTime of object _Application failed. When I select Help from the Debugger, I get a blank page. VBA help is installed. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OnTime method | Excel Programming | |||
ontime method? | Excel Programming | |||
ontime method? | Excel Programming | |||
ontime Method | Excel Programming | |||
Help me with OnTime Method | Excel Programming |