Pausing and resuming a running macro
 

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

Pausing and resuming a running macro
 

The Wait method will pause

Important The Wait method suspends all Microsoft Excel activity and may
prevent you from performing other operations on your computer while Wait is
in effect. However, background processes such as printing and recalculation
continue.

To be able to exit a subroutine and return to it while keeping the variables
from being reinitialized, make the subroutine Static.

"brian" wrote:

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

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