+ Reply to Thread
Results 1 to 2 of 2

Loop through a certain number of rows

  1. #1
    Forum Contributor
    Join Date
    10-01-2013
    Location
    United States
    MS-Off Ver
    Microsoft version 365
    Posts
    111

    Loop through a certain number of rows

    How do you loop through 2000 rows at a time then start the loop again?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: Loop through a certain number of rows

    There are different ways to do this and some are better than others depending on your situation.

    Please describe what work you want to do inside the loop, and how you know what rows to include. If you want to "start the loop again" that implies that you want a loop inside a loop. How many times are you going to start again? How do you know when you don't want to start again?

    It would be better to show what code you have now, and best of all to attach your file.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Loop to copy rows of data to another sheet if version number is higher
    By mattyfaz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2015, 11:55 PM
  2. [SOLVED] Loop through rows (Dynamic number)
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2014, 02:29 PM
  3. [SOLVED] Macro to loop through dynamic number of rows checking adjacent for certain criteria
    By ellismith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2014, 04:12 PM
  4. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 PM
  5. Do-While loop within a do-while loop? Dealing with changing number of rows
    By Motox in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2012, 12:59 AM
  6. Loop to Sum Unknown Number of Rows
    By DBExhale in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2010, 07:19 AM
  7. Loop instructions for number of active rows
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2008, 10:29 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