+ Reply to Thread
Results 1 to 2 of 2

Loop Sub routine until no more data

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Hartland, WI
    MS-Off Ver
    Excel 2013 Professional Plus
    Posts
    73

    Loop Sub routine until no more data

    I have an add-in that can run the code below. It works fine, however, I need it to run whether there is just one row of data, or 100 rows of data. I have headers, so the first row of data starts in row 2, and the last no matter what will be in row 100 (so 99 rows of actual data technically). There are usually only 10 rows of actual data as the rest are usally set to blanks with iferror. The code below works, but I need it to run for however many rows of actual data there are. Any ideas?

    Please Login or Register  to view this content.
    Last edited by gillyr7; 06-16-2014 at 10:18 AM.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Loop Sub routine until no more data

    Hi gillyr7,

    Untested as I don't have the correct data, but try this:

    Please Login or Register  to view this content.
    HTH

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ 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 a sub routine
    By obiwann in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-07-2014, 09:08 PM
  2. Pass a variable from one sub-routine to another sub-routine
    By gowtham_pec in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-01-2013, 07:07 PM
  3. Add second private sub routine within a loop
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2010, 03:02 PM
  4. VBA routine gets slower and slower on each iteration of the main loop
    By whitespaces in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-15-2009, 03:29 AM
  5. [SOLVED] Loop routine fails after 10 cycles......
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2006, 11:50 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