Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Debugging a long macro
#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


Messages In This Thread
Debugging a long macro - by rhadkins2002 - 06-17-2019, 02:20 PM
RE: Debugging a long macro - by Gintaras - 06-17-2019, 03:38 PM
RE: Debugging a long macro - by rhadkins2002 - 06-22-2019, 08:07 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)