View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Pause code in vb

application.Wait now+timevalue("0:0:5")

HTH
--
AP

"Greg" a écrit dans le message de news:
...
Hi all,

How do I get a macro to pause for 5 seconds and then continue with the
rest of the code?

Thanks

Greg