See the examples at
http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy



"Tim Williams" wrote:

application.ontime

Tim


"Joey Lichtenstein" wrote in message ...

Is there a better way of pausing Excel than:

Application.Wait waitTime

I have code that I would like to run either every 30 minutes or every 60
minutes, but I really hate the way the Appliaction.Wait function works.
(The way it just locks up the application.)

Thanks!

Joey