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 |
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 |