vba step into code

[Noz2k]

Is there a way to step into the procedure at a certain point, or alternatively to skip to the end of a loop.

It's really frustrating having to go through certain loops (ones which go through over 100 times) just to get to the bit of code I'm interested in seeing.

 

[GlennUK]

You can set breakpoints ( click at left of code so as to turn row maroon ), or just select the row of code you want to examine and choose Run To Cursor ( Ctrl+F8 ).

 

[Noz2k]

ah ok, thanks Glenn

 

[villy]

you can add some code to step into..
for example I have 50 times loops and I want only to know the value between 25 and 30 I will add condition.

...
for i=2 to 50
while (i >= 25 and i <= 30) ' condition to perform only between 25 to 30
[I]...do your code[/I]
wend
next i

 

[GlennUK]

you can add some code to step into..
for example I have 50 times loops and I want only to know the value between 25 and 30 I will add condition.

...
for i=2 to 50
while (i >= 25 and i <= 30) ' condition to perform only between 25 to 30
[I]...do your code[/I]
wend
next i[/QUOTE]I would never do that when you can add watches to trigger under any specific condition. ( Debug Add Watch, or right click any variable or calculation and choose Add Watch ... you can set a clause like i=30 and choose to break when clause is True )