View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Pausing and resuming a running macro

You could add a wait

Application.Wait Now + TimeValue("0:00:10") ' 10 secs

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"brian" wrote in message
...
Is there a way to pause a running macro at a certain stage of its

execution
and to then to resume it? Thanks for any help.

TIA
Brian