Thread: Loop Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Birley Dave Birley is offline
external usenet poster
 
Posts: 171
Default 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