Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to break out of an if statement and continue to loop
I'm really stuck. I grab a value from one page and go to another page to
find a match. All is well unless I can't find a match. I need to break out of the inner loop and continue the outer. Here is my code. I can't figure out how to break out yet continue execution. Thanks (outer loop is here) Do Until StrComp(destin_unit, source_unit) < 0 If cntr2 < text_max_rows Then cntr2 = cntr2 + 1 destin_unit = Cells(cntr2, 1) Else cntr2 = cntr3 + 1 'I need to break here and continue the outer loop End If Loop |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to break out of an if statement and continue to loop
Replace: 'I need to break here and continue the outer loop
With: Exit Do Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to break out of an if statement and continue to loop
Do you want something like this?
Sub demo() For i = 1 To 100 greatescape = False Do Until (StrComp(destin_unit, source_unit) < 0) Or greatescape = True If cntr2 < text_max_rows Then cntr2 = cntr2 + 1 destin_unit = Cells(cntr2, 1) Else cntr2 = cntr3 + 1 greatescape = True End If Loop End Sub -- Gary's Student gsnu200705 "Darren" wrote: I'm really stuck. I grab a value from one page and go to another page to find a match. All is well unless I can't find a match. I need to break out of the inner loop and continue the outer. Here is my code. I can't figure out how to break out yet continue execution. Thanks (outer loop is here) Do Until StrComp(destin_unit, source_unit) < 0 If cntr2 < text_max_rows Then cntr2 = cntr2 + 1 destin_unit = Cells(cntr2, 1) Else cntr2 = cntr3 + 1 'I need to break here and continue the outer loop End If Loop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break out of a loop in Excel2007? | Excel Discussion (Misc queries) | |||
Is there a break statement in VBA | Excel Programming | |||
How to continue loop after deleting row? | Excel Programming | |||
continue statement in a loop | Excel Programming | |||
How do you test to break out of a find loop? | Excel Programming |