I have to run a certain VB macro every half hour, starting at 07:00 am till 17:30 in the afternoon.
At the moment I am using a series of

Application.OnTime Time Value ("07:00:00"), "macro to run"
Application.OnTime Time Value ("07:30:00"), "macro to run"
etc etc...

Surely there must be a more "economic" way to do it (a loop?)

Many thanks

BC