Maybe silly question: Is it possible to only execute part of a macro for debug purposes?

[Shanyn]

Hi there.

So. Let's say I'm still in the process of writing my macro. I run it, everything works. I add a few lines of code and want to make sure the new lines of code work.

As far as I know, the only way to test the new code I wrote is to run the entire macro again? If I try to put the cursor on the first new line and step through the code with F8, it always jumps to the beginning of the code. I'd really like to just run those last lines that I added if there's any way to do that. I already know the rest of the code works, after all. Am I missing a way to do this?

Thanks in advance.

Edit for tl;dr: I know how to run only part of the macro IF I want to start at the beginning and step through or set a break point. But I want to start in the middle somewhere.

[MarvinP]

Hey Shanyn,

Have you tried those few lines of code in the immediate window?

I do this lots of times.

For example: A few days ago in the middle of a macro I wanted to clear contents for columns A, B and C. I know there are different ways to select the entire column but tried a few in the Immediate Window.

Columns(A,B,C).select 'didn't work
Columns("1:3").select 'didn't work either
Columns("A:C").select 'works but is there an easier way?
Range(cells(1,"A"),cells(1,"C")).entirecolumn.select ' Excel also likes this line

All the above are tried in the Immediate window to see if VBA will like them before sticking them into my REAL code.

I think you get what I'm hinting at.

[Shanyn]

I'm self-taught and had never heard of the Immediate Window. Thanks for giving me a new search term to fawn over. That looks like it will work okay.

[trevor69]

Hi,
what you can do is use a goto at the top of your code, perhaps put it after any declarations/Dims, or not it's up to you, but if your code requires them it will fail.

and then point it to were you want to start.

Please Login or Register  to view this content.