Thread: Pause a Macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JeffR JeffR is offline
external usenet poster
 
Posts: 7
Default Pause a Macro

Thanks!

"Gary Keramidas" <GKeramidasAtMsn.com wrote in message
...
you can try this:

Application.Wait (Now + TimeValue("0:00:01"))

--


Gary

"JeffR" wrote in message
...
Is there a way to pause a looping macro, such as 1 second at the bottom
of each loop?