exactly:
Important The Wait method suspends all Microsoft Excel activity and
may prevent you from performing other operations on your computer while
Wait is in effect. However, background processes such as printing and
recalculation continue.


thus a "timer" may be a bit more comfortable..


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Henry wrote :

Ram,

You don't need the For Next loop.
Application.Wait Now +(TimeValue("00:00:05")) will give you a five
second delay.
Application.Wait Now +(TimeValue("00:03:10")) will give you a three
minutes and ten seconds delay.
Application.Wait Now +(TimeValue("10:25:37")) will give you a ten
hour, twenty-five minutes and 37 seconds delay.
Etc., etc.
You may have to adjust the delay to take account of the length of
time that your program takes to run.

Do
'Your program here
Application.Wait Now +(TimeValue("00:00:05"))
While Now < TimeValue("17:00:00") 'Stops at 5PM

or use While 1<0 'to run continuously

Henry


"Ramthebuffs"
wrote in
message
...

I ended up using
Application.Wait Now + (TimeValue("00:00:01"))
along with a for next loop. Its not really pretty but gets the job
done for now.


--
Ramthebuffs
--------------------------------------------------------------------
---- Ramthebuffs's Profile:
http://www.excelforum.com/member.php...o&userid=16429
View this thread:
http://www.excelforum.com/showthread...hreadid=380747