If you knew ahead of time where you wanted to pause, you could put a break in
the code (F9). I sometimes use a counter. When the counter reaches preset
values, the code pauses. Play or F5 continues the macro from the break point.
-Chris

"phil2006" wrote:


When macros are running is there any way in which you can pause them,
save and resume?

Thanks.


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=556419