Executing code every hour

Hi guys

Im trying to execute a set of code every hour.

I tried adding Call scheduletimer() to the code i want to loop and

Sub scheduletimer()

 Application.OnTime Now + TimeValue("01:00:00"), "Scheduling_Click" 

End Sub

But i keep getting the error

Error BC30456 ‘OnTime’ is not a member of ‘Application’.
Error Method arguments must be enclosed in parentheses.

Any idea how to get around this ?

submitted by /u/Sharingan_
[link] [comments]

Leave a Reply