Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Problem
I have a construct like this:
Do While Yadda Yadda If More Yadda Then If Still More Yadda Then Loop End If End If Loop Now, obviously that inner "Loop" can't fire because it can't find a matching "Do", but I don't want to fire off an "Exit Do" because that sends me outside the Do..Loop, where some core numeric variables are set, and that isn't what I have in mind <g! So, how do I get to the top of the Do..Loop from that inner location? -- Dave Temping with Staffmark in Rock Hill, SC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Problem
give the last loop a label, like Continue:
then instead of your Loop, use Go To Continue: Do While Yadda Yadda If More Yadda Then If Still More Yadda Then GoTo Continue End If End If Continue: Loop "Dave Birley" wrote: I have a construct like this: Do While Yadda Yadda If More Yadda Then If Still More Yadda Then Loop End If End If Loop Now, obviously that inner "Loop" can't fire because it can't find a matching "Do", but I don't want to fire off an "Exit Do" because that sends me outside the Do..Loop, where some core numeric variables are set, and that isn't what I have in mind <g! So, how do I get to the top of the Do..Loop from that inner location? -- Dave Temping with Staffmark in Rock Hill, SC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Problem
Aaaaah, yes! Was the first language we old farts ever learned BASIC, where
GoTo was a way of life? I even had a time where I played with C and C++, and, once again GoTo was okey-dokey. But for most of the past 20+ years, I have lived in the Visual FoxPro environment, where GoTo hath no home, so I never thought of such a simple solution. Thankee for bringing me into the fold <g! -- Dave Temping with Staffmark in Rock Hill, SC "Bob Umlas, Excel MVP" wrote: give the last loop a label, like Continue: then instead of your Loop, use Go To Continue: Do While Yadda Yadda If More Yadda Then If Still More Yadda Then GoTo Continue End If End If Continue: Loop "Dave Birley" wrote: I have a construct like this: Do While Yadda Yadda If More Yadda Then If Still More Yadda Then Loop End If End If Loop Now, obviously that inner "Loop" can't fire because it can't find a matching "Do", but I don't want to fire off an "Exit Do" because that sends me outside the Do..Loop, where some core numeric variables are set, and that isn't what I have in mind <g! So, how do I get to the top of the Do..Loop from that inner location? -- Dave Temping with Staffmark in Rock Hill, SC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For Loop Problem | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Problem with Do Loop and If | Excel Programming | |||
Problem with Loop | Excel Programming | |||
For..Next loop problem | Excel Programming |