+ Reply to Thread
Results 1 to 4 of 4

Use a loop but skip a row

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    Use a loop but skip a row

    Hi,
    If I am using a loop to repeat the same process for each row, but I want to skip a row, how would I do that?

    Alex

  2. #2
    Registered User
    Join Date
    03-06-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Use a loop but skip a row

    Skipping blank rows or perform the macro on every other row.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Use a loop but skip a row

    If it's one specific row you could just have something like this.
    Please Login or Register  to view this content.
    Obviously that's psuedo-code, I don't know how you are looping.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    08-22-2012
    Location
    nj, us
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: Use a loop but skip a row

    add 1 to the integer in the loop when you want to skip

    also :

    Please Login or Register  to view this content.

+ 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. Skip to next record in For...Next Loop if condition not met
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 04:12 PM
  2. [SOLVED] Skip loop if cells equal same values
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2012, 01:19 PM
  3. How to skip special cases in a For Each loop
    By smohyee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2011, 02:20 PM
  4. Skip to next For loop based using If statement
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 08-25-2010, 09:56 AM
  5. skip hidden rows in loop
    By secondrate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2010, 08:41 AM

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