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