How do debug a loop?

I'm running code that includes several loops and am getting an error that says:

"Run-time error '13':

Type mismatch"

When I get back to the code it doesn't highlight anything or give any indication of where the error is.

The loop puts calculated values into excel, so I can tell around where in the loop the error occurs from that. However, I can't easily determine the line of code that's causing the problem.

Is there a way to quickly jump to the error?

Please Login or Register  to view this content.

It didn't highlight on mine, but I changed it to 176 and it runs now. The logic is wrong somewhere since it outputs some values to the wrong location, but at least it runs all the way through. I'll try to fix it myself before reposting.

Originally Posted by tehneXus

Hi,

for me the following line is highlighted:

Please Login or Register  to view this content.

caused when ArrayCount = 146 as ProRata(146) is empty because the first loop ends at 145..

Loop Calc Excel Forum Example updated.xlsx

Here is an example. Line 8 in the sample is where line 176 is in the actual one.

I'm no expert, but when I run into this situation:

1. I put a 'debug.print' statement in the loop to find out how many loops completed. The immediate window (CTRL G)
in the debugger will display the output.

For example:

Please Login or Register  to view this content.

2. Say you find that it stops after '45' is printed.

Modify the code to start the debugger on arraycount 45. I either of two techniques:

Please Login or Register  to view this content.