Macro Wait command
 

This worked for me

Application.Wait TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) +
10)

This will pause the code for 10 seconds

Hope this helps


--
fastmonkey512
------------------------------------------------------------------------
fastmonkey512's Profile: http://www.excelforum.com/member.php...o&userid=23982
View this thread: http://www.excelforum.com/showthread...hreadid=375992