| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| why does my "TAB" key skip a column in excel spread sheets? | Excel Worksheet Functions | |||
| Question on "On Error GoTo skip" | Excel Discussion (Misc queries) | |||
| How do I run a macro from inside an"=IF" formula in Excel 2003? | Excel Worksheet Functions | |||
| skip checkbox to next tab with "enter" | New Users to Excel | |||
Threaded Mode
