Im trying to execute a set of code every hour.
I tried adding Call scheduletimer() to the code i want to loop and
Application.OnTime Now + TimeValue("01:00:00"), "Scheduling_Click"
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 ?