Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
PS....
"Mike" wrote: LOOP over t while condition3 as below: WHILE( PlnHrznTop <= ts AND Continue < 0), LOOP( t while (ORD(t) = PlnHrznTop), Two more possible interpretations of your cryptic pseudocode come to mind. Again, this might be misdirection. If PlnHrznTop <= ts And Continue < 0 Then Do [...some code...] Loop While ORD(t) = PlnHrznTop And PlnHrznTop <= ts And Continue < 0 End If --or-- Do While PlnHrznTop <= ts And Continue < 0 Do [...some code...] Loop While ORD(t) = PlnHrznTop Loop PS: The outer Do While...Loop could be written using While...Wend. I kept it as Do While to demonstrate that the looping constructs can be nested. I did not want you to misunderstand that one must be While...Wend if the other is Do...Loop. PPS: I tend to use Do While...Loop instead of While...Wend because we can use Exit Do in the middle. There is no Exit While; we must use Go To. No biggie; it's just a style thing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |