View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default Skip to Next "x" inside of a For Next Loop

Hi,



For x = 1 to 100
Criterion 1
Criterion 2
if criteria 2 i= true then goto nextxline 'in on word, it is just a
label
Criterion 3
Criterion 4
nextxline :
Next x
Regards,

Jean-Yves



"verizon" wrote in message
...
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