Debugging a long macro

[rhadkins2002]

Is there a way to have a macro resume where I found the error instead of starting from the beginning each time?

It is making a lot of changes to my document, which is it's purpose UNTIL IT BREAKS. Then I have to go back and undo all those changes manually, one at a time, to rerun the macro.

[Gintaras]

No, cannot resume on error.

[rhadkins2002]

Wellllll, sort of I can.  I've broken my macro into sections, each with their own label. I've slowed the speed of the macro down to a very snail-like pace and when the macro does something I don't want it to do, I hit the PAUSE key to stop the macro. I'll look to see what section I'm in, make the fix and then put a goto statement near the top of the macro so it goes to that section to 'resume' from where it broke. This way I get to inch along fixing things as they turn up without having to undo every entry created by the working sections of the macro.