Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Debugging a long macro
#1
Is there a way to have a macro resume where I found the error instead of starting from the beginning each time? Huh

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. Angry
Richard H Adkins Jr
AUTHOR | SURVIVOR

Authors Guild of America
Romance Writers of America
Science Fiction & Fantasy Writers of America
#2
No, cannot resume on error.
#3
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. 
Big Grin
Richard H Adkins Jr
AUTHOR | SURVIVOR

Authors Guild of America
Romance Writers of America
Science Fiction & Fantasy Writers of America


Forum Jump:


Users browsing this thread: 1 Guest(s)