+ Reply to Thread
Results 1 to 2 of 2

How to find sheet having the fewest rows of data?

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to find sheet having the fewest rows of data?

    Hi All,

    I am wondering how to find, in a workbook of any potential number of sheets, the sheet with the fewest rows of used data. If possible, I would prefer to avoid using the "UsedRange" property, given the drawbacks of that method.

    Thanks in advance,

    LOBF

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: How to find sheet having the fewest rows of data?

    It does use UsedRange but if you know more about the structure of the sheets you could change the calculation.

    Please Login or Register  to view this content.


    click on the * Add Reputation if this was useful or entertaining.

+ 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] Check Column data in two rows is match for data in two rows on another sheet and return
    By Iain Clarendon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2015, 09:25 PM
  2. Complex Logic Question: Find Fewest Lanes Required
    By bowater in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2015, 04:10 AM
  3. Replies: 0
    Last Post: 07-21-2015, 10:26 PM
  4. Replies: 4
    Last Post: 11-13-2013, 11:15 AM
  5. Replies: 1
    Last Post: 08-24-2013, 07:01 AM
  6. Find rows in 1 sheet that are not in another
    By promithius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2013, 09:23 AM
  7. How to open up 50 text files in 1 worksheet in fewest moves?
    By UCI_guy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 04:05 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