Divide it into two macros
End the first macro. Provide some way to execute the remainder.

--
Regards,
Tom Ogilvy



"Art Parra" wrote in message
...
How do I include a "pause" and restart option on the following macro? I
have a while variable othervariable count records where certain
conditions are met and exit when othervariable is equal to variable. The
macro redraws some charts so it looks like a dynamic chart. I want to
pause the while and continue at any time.

thanks,