pausing an Excel macro

Posted by Derek on November 19, 2001 8:05 PM

I want my macro to pause for 5 seconds between actions.
I have tried Application.Wait( ) but the prompt says to enter boolean time in the brackets. What is that?

Posted by Chris Rock on November 19, 2001 8:18 PM

I don't know why I am up at 11PM surfing the Mr. Excel site, but here's a post that may help you:
30260.html

I had the same question once and the answer was similar.

Hope this helps

Posted by Derek Baldry on November 19, 2001 10:07 PM

Thanks Chris, that's great.