Loop prevents debugging

[bibu]

Hi, this is probably just me being bad at VBA, but I'm getting frustrated trying to debug a macro. Pressing F8 to take it step by step never reaches the part where I think the problem is, because in between there is a loop that will never end no matter how many times I press F8. Any ideas as to how I can solve this? TIA.

[protonLeah]

You must post the code.

[AB33]

What kind of a loop is? Is do while or do until?

[bibu]

Sorry, here it is:

Please Login or Register  to view this content.

[Norie]

Where is the problem?

[bibu]

There is another "main" macro that calls this macro. I think I can solve the problem on my own, but I can't get to it because the loop in this macro never ends. I thought it would end because "r" is only 50 rows long, so it should end eventually, but it doesn't, unless I press F5.

[protonLeah]

At the left side of the code pane there will be an execution point arrow when you are stepping through the code. You can click and drag the arrow down out of the loop

[bibu]

This worked, thanks a lot!