Try this:

Sub waiting()
Application.Wait (Now + TimeValue("0:00:10"))
MsgBox "Hello"
End Sub

Or, you may also have a look at the OnTime method.

Regards,
Edwin Tam

http://www.vonixx.com


"Gazzr" wrote:


Hi,

Is there anyway to tell a macro to "Pause" when it gets to a certain
stage for a set amount of time?

After the set amount of time I need it to start again!

Any ideas?
Regards
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=534402