Conditionally change nested loops

**Andy L Gibson** · 04-26-2014, 01:36 AM

Hi all. I'd like to be able to conditionally change the number of nested loops.

do 
 do
 'exit command
loop
 'exit command
loop

That's fine. But I'd like to be able to have, say 3 or more nested loops depending on variables supplied.

Kind regards

Andy G

**Joakim N** · 04-26-2014, 04:05 AM

Maybe you can use Select Case

Select Case your_variable
Case "case 1"
    Do
        ...
        Do
            ...
        Loop
    Loop
Case "case 2"
    ...
Case "case 3"
    ...
End Select

**Andy L Gibson** · 04-26-2014, 11:21 PM

Thanks so much Joakim!

That should work ok, I guess I could branch to separate functions for added eloquence. I'll keep the thread open a little while in case of other replies. I was considering recursion but couldnt get my head around it.

Andrew