Help Editing Macro Code

[tcnt9176]

I have some lengthy macros that I have to edit and test. After adding certain commands i.e. sorting, excel says that this will end the playing of the macro and I have to start over but I really need to test from the middle of the macro so I hit F8 & drag the arrow to where I want it to start which takes a few minutes b/c the macro is so long. Is there any way to make this quicker where I don't have to drag the arrow all the way down to start the macro at a certain point.
Thanks, Chris

 

[war4peace]

You may want to split the macro into functions and just run the appropriate function. Or you could copy/paste the relevant code into a different sub and just run that sub.

 

[tcnt9176]

So there's no way to have the play button skip to a bookmark or breakpoint?

 

[war4peace]

There is. Start the macro by pressing F8, then scroll down to the statement that you wish to start with and press Ctrl+F9. Or go to Debug menu and click on Set Next Statement.

 

[tcnt9176]

Perfecto!!! I knew there had to be an easier way. This is going to save me a ton of time!!!! Thanks.