+ Reply to Thread
Results 1 to 5 of 5

Staggered/Split For Loops

  1. #1
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Staggered/Split For Loops

    Hi All,

    Not sure if staggered/split for loop is the correct term. However, I was wondering it is possible to have a for loop last skips number.

    Something like:

    For i=1 to 3 and i=5 to 10

    Next i

    Thanks, Natalie
    Last edited by NatalieEC; 02-03-2015 at 10:22 AM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Staggered/Split For Loops

    No.
    Please Login or Register  to view this content.

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Staggered/Split For Loops

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Staggered/Split For Loops

    Are there a lot of skips in your For Next Loop?

    If there are perhaps the above is a little too simple??

    Give us a better example and an Array answer might be better.
    Last edited by MarvinP; 02-02-2015 at 07:02 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Staggered/Split For Loops

    Thanks everyone, these are all great!

    I can definitely use all these!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] staggered email send
    By okmijn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2021, 12:15 AM
  2. Staggered rent formula
    By macy liew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2014, 10:29 AM
  3. staggered formulas
    By amartino44 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2013, 12:44 PM
  4. Add row to table and reformat the staggered coloring
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2013, 05:53 PM
  5. Compile staggered data into a single row
    By jboomer in forum Excel General
    Replies: 3
    Last Post: 11-13-2009, 02:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1