View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Pausing code execution

Rohit,

You could try this:

Application.Wait Now + TimeSerial(0, 0, 5)

John

Rohit Thomas wrote:

Hello All,

I would like to pause code execution for approx five secs
before running the next set of statements. Is this the
correct code to do that???

****some code here****
Application.Wait (Now + TimeValue("0:00:05"))
****some code here****

Thanks,
Rohit