Exiting a double for loop

[GeneralShamu]

I have the following setup

For i = 1 To #
For j = 1 To #
if (i = 5 & j = 7)
[exit both for loops]
end if

Next j
Next i

Does anyone know how to do that? If I put 'Exit For' in the if body, would it still read code up to the 'End If'?

 

[Weaver]

Wouldn't this work

for i = 1 to 5
For j = 1 To 7

'do whatever

Next j
Next i

or am I missing something?

 

[RoryA]

For i being 1 to 4, they may want more than 7 values of j processed, and also there might be other code in the For i loop that they want skipped when i = 5 and j = 7.

 

[Weaver]

For i being 1 to 4, they may want more than 7 values of j processed, and also there might be other code in the For i loop that they want skipped when i = 5 and j = 7.

If it was just skipping a process I'd see where you were coming from, but both loops are being terminated. Also if the first was true, you could set a condition to control the upper limit of J when I was >4.

 

[RoryA]

Also if the first was true, you could set a condition to control the upper limit of J when I was >4.

I don't see how that relates to what you posted?

 

[Rick Rothstein]

I don't see how that relates to what you posted?

I think what Weaver meant is something like this this...

For i = 1 To 5
    For j = 1 To #
        '   possible code here
        If i = 5 Then Exit For
        '   possible code here
    Next j
Next i

where the # symbol could be any large number more than 7.

 

[RoryA]

Maybe, but that's not at all the same as:

for i = 1 to 5
For j = 1 To 7

which was my point. It also wouldn't stop any code after the 'Next j' from processing, so not a true exit from both loops.