Try using the word "Stop" (no quotes) in your code wherever you want it to
stop. That's what I do for testing purposes. Of course you would have to
manually continue.

Regards,
Paul

--

"Nikki" wrote in message
...
Can anyone please tell me what code would work to stop a Macro when
updating
multiple sheets? I have about 12 sheets and only need 8 updated every
month;
the other 4 are only required to be updated every 3 months.

Thanks