View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
verizon verizon is offline
external usenet poster
 
Posts: 13
Default Skip to Next "x" inside of a For Next Loop

Hello

In a large For Next loop, I have many criteria. If any one of these
criteria is a certain value I want to immediately go to the Next x. How can
I do that:

For x = 1 to 100
Criterion 1
Criterion 2
Criterion 3
Criterion 4
Next x

If, say, Criterion 2 is true, I would like to go immediately to the Next x
without considering Criteria 3 and 4.

I cannot figure out how to advance the Next x.

Thank you.

W