Macro Testing - Running from a given point

[JimM]

Hi all

Is there any way I can run a macro from a certain point rather than having to start from the begining each time ?

I know I could 'comment' all the code up to my start point but that means that when I uncomment it all afterwards I'll have to go through and re-comment all the lines that actually are comments ! (If that makes sense)

Thanks

Jim

 

[moonfish]

This is rather unorthodox but you could use GoTo:

Sub example()
    GoTo whereToStart
    code
    whereToStart:
    more code
End Sub

DISCLAIMER: never use GoTo statements. very prone to errors, usually causing infinite loops, etc.

 

[Hermanito]

It all depends on what the part of the code does that you wanna skip...
If the rest of the code relies on it, you will get in trouble anyway.

Or you could split up your code into functional blocks, and only run those blocks you need from within a separate sub. That way you can turn blocks of code on and off with just commenting one call, instead of the whole codeblock

By the way, commenting and uncommenting whole blocks of code is very easy. Just make sure you have the Edit toolbar visible. It has two buttons that do just that with all code you have selected...

Edit: I second moonfish: do NOT choose the GoTo option