debugging in loop

[MaartenRo]

Hi,

I would like to check wheter a certain part of a macro is without bugs. The problem is that if the part i want to check is in row 35 i have to press F8 for a long time before getting at the point i want to check. In what way can i do this faster?

Any input is much appreciated!

[huuthang_bd]

Hi,

Put the cursor at row 35 and then hit F9 to insert a breakpoint. The macro will stop at breakpoint for debugging.

[MaartenRo]

Thank you for your advice but i mean that if you have a loop with 35 rows in a column in a spreadsheet with if then statements, i would like the script to stop at row 35 so i can run each line of code with F8.

[huuthang_bd]

Assume you want to debug when variable i = 35, click Debug - Add Watch..., type i = 35 into Expression box and select Break When Value Is True and then click OK.

[Fluff13]

Another option is to use debug.assert like

Please Login or Register  to view this content.

which will stop when i=35