how to skip an instance in a loop

**luv2glyd** · 12-08-2015, 01:19 PM

If instead of running a loop from 1 to 10, is there a simple way to change they syntax to run it from 1 to 5 and 7 to 10 or or would I have to run two loops now?
So looking for something similar to this:

Please Login or Register  to view this content.

instead of this:

Please Login or Register  to view this content.

Thanks

**gmr4evr1** · 12-08-2015, 01:34 PM

Maybe

Please Login or Register  to view this content.

**excel_bat** · 12-08-2015, 01:34 PM

Hi, a conditional in between could work:

Please Login or Register  to view this content.

**GC Excel** · 12-08-2015, 01:35 PM

Here's a suggestion:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 12-08-2015, 03:08 PM

Another:

Please Login or Register  to view this content.

**luv2glyd** · 12-09-2015, 01:03 PM

Ok, looks like a conditional is the way to go. Thanks everyone.

how to skip an instance in a loop

LinkBack

Thread Tools

Rate This Thread

Display

how to skip an instance in a loop

Re: how to skip an instance in a loop

Re: how to skip an instance in a loop

Re: how to skip an instance in a loop

Re: how to skip an instance in a loop

Re: how to skip an instance in a loop

Thread Information

Users Browsing this Thread

Similar Threads

Skip in loop if condition in loop is met

[SOLVED] For loop - skip to next cell in range

[SOLVED] Skip row in For...Next loop to automate e-mails

[SOLVED] Skip blank cells in a loop

Use a loop but skip a row

How to skip special cases in a For Each loop

Changing the condition of a For Each loop for a single instance

Bookmarks

Bookmarks

Posting Permissions