Application.OnTime TimeValue to reference from Cell range

Topic

New Reply

What is the syntax for the OnTime TimeValue if it was to have the Value from a worksheet cell reference,

Code:

Application.OnTime TimeValue = Sheets(“ONE”).Range(“A1”).Value, “MACRO_1”

as opposed to to this syntax

Code:

Application.OnTime TimeValue(“11:45:00”), “MACRO_1”

The error message is,
Compile error:
Argument not optional

value in Cell A1 is in Time format, with seconds.

Thanks

Reply | Quote