For-next loop question

[Luke]

I have a for-next loop, within which I want to check to see if a certain
condition is true. If it is true, I want to skip the rest that particular
iteration and move on to the next one in the loop. I tried code that looked
like the following, but it just gave me a "next without for" error:

For x = 1 to 11
If condition = true then
next x
End if
Next x

I want to do this without using a GoTo statement. Any suggestions?

 

[Paul C]

There is no built in "Skip to next" function the only loop command available
is Exit For, which is not what you want.

A Goto is really the best option, but if you really do not want to use one
you can use an additional single loop with an Exit For like this.

For x = 1 To 11
For A = 1 To 1
'Condition Check
If Condition = True Then Exit For
'Do more stuff here if Condition=false
Next A
Next x

 

[Ryan H]

Change the If...Then statement to False. If its, True it will go to the next
x. Hope this helps! If so, let me know, click "YES" below.

For x = 1 to 11
If condition = False then
next x
End if
Next x

 

[Luke]

Thanks. I'm not against GoTo's as such, but would rather not use them if
possible. But you're right - it does appear to be the best option in this
case.

 

[Ryan H]

Correction.

For x = 1 to 11
If condition = False then
' do something
End if
Next x

 

[Luke]

There's a thought. I'm learning that it is sometimes easier to accomplish
what you want if you test for the opposite of what you want. Thanks.

 

[Jef Gorbach]

There's a thought.  I'm learning that it is sometimes easier to accomplish
what you want if you test for the opposite of what you want.  Thanks.

How about checking condition before the for .. next?

Do While condition = True