+ Reply to Thread
Results 1 to 3 of 3

Find Last Used Row even if Hidden

  1. #1
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Find Last Used Row even if Hidden

    I have a worksheet for data entry. I've added data validation thousands of rows ahead of the last used row, so that I won't "run out". To get the last used row, I use Range("A1000000").End(xlUp).Row. If I use UsedRange.Rows.Count it counts the thousands of blank rows with data validation. Sometimes, rows are hidden and End(xlUp) skips them. How do I find the last used row, even if it is hidden?
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,879

    Re: Find Last Used Row even if Hidden

    Check Ron de Bruin solution: http://www.rondebruin.nl/win/s9/win005.htm
    Best Regards,

    Kaper

  3. #3
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Find Last Used Row even if Hidden

    Thanks!

    For posterity: the solution I used was
    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. [SOLVED] I can't find my hidden worksheet
    By aresquare1 in forum Excel General
    Replies: 8
    Last Post: 04-26-2019, 03:31 PM
  2. [SOLVED] Using FIND with and without hidden columns.
    By TG58 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-23-2016, 06:39 PM
  3. Can not find hidden row in excel
    By ACrossley1 in forum Excel General
    Replies: 6
    Last Post: 08-20-2015, 06:23 AM
  4. [SOLVED] Hidden Frames, cannot find them
    By ciresuark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 04:26 PM
  5. [SOLVED] How to find hidden text
    By Judy Ward in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2006, 09:35 PM
  6. Find Value in Hidden Cells
    By Josh Sale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-02-2005, 06:05 PM
  7. Using .Find with Hidden Columns
    By D in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2005, 03:06 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