View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach[_2_] Jef Gorbach[_2_] is offline
external usenet poster
 
Posts: 65
Default For-next loop question

On Feb 19, 3:45*pm, Luke wrote:
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.



"Ryan H" wrote:
Correction.


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


--
Cheers,
Ryan


"Luke" wrote:


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?


How about checking condition before the for .. next?

Do While condition = True