M
Mike H
how can I jump out of a for next loop before I get to the top of the series
of numbers?
of numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeroen Schouten
If <condition> Exit For
F
Frank Isaacs
Check out Exit in the online help; it's used for this situation (Exit For)
as well as others (Exit Do, Exit Sub, Exit Function, etc.).
--
HTH -
-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
as well as others (Exit Do, Exit Sub, Exit Function, etc.).
--
HTH -
-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
C
Chrissy
Rethink your loop control.
Maybe you should not be using a for next loop - maybe a do while
loop would be better.
Chrissy.
Maybe you should not be using a for next loop - maybe a do while
loop would be better.
Chrissy.
T
Tom Ogilvy
for each cell in Range("A1:A200")
if isempty cell then exit for
' code to execute
Next
for i = 1 to 1000
if [test condition] then exit for
' code to execute
Next i
if isempty cell then exit for
' code to execute
Next
for i = 1 to 1000
if [test condition] then exit for
' code to execute
Next i