This example pauses a running macro for approximately 10 seconds.

newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime

------------
That was copied directly from VBA help. Search for the 'wait' functio
to find out more.

-Gitcyphe

--
Message posted from http://www.ExcelForum.com