ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loop Problem (https://www.excelbanter.com/excel-programming/389159-loop-problem.html)

Dave Birley

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

Bob Umlas, Excel MVP

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


Dave Birley

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



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com