+ Reply to Thread
Results 1 to 3 of 3

How to get the last row and column of a range

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Japan
    MS-Off Ver
    Excel 2010
    Posts
    6

    Question How to get the last row and column of a range

    Hello All,

    I'm struggling with the following.

    In a worksheet I define a subrange with 2 cells, c1 and c2 like c3 = range (c1, c2). Then, in that subrange I need to find the bottom right used cell (last used cell). Typically this is what is returned by UsedRange in a worksheet.

    Thus to find that "last used cell" in my subrange only, I've tried using SpecialCells(xlCellTypeLastCell) which is supposed to apply on a range (not on the whole worksheet).

    Unfortunately, when I use SpecialCells(xlCellTypeLastCell) on my subrange c3 I have the same result as if I apply it in the whole worksheet :/

    How can get the "last used cell" of my subrange without regard to the complete worksheet ? All cells out of my subrange have no interest in my case...


    Any highlight will be very welcome...
    Thanks,

    Alexandre

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: How to get the last row and column of a range

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Japan
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: How to get the last row and column of a range

    So quick and so efficient !

    Thanks a lots, works perfectly well

+ 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] Sum column AB by date range in Column N and text in column X
    By richtree in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2014, 12:04 PM
  2. Replies: 4
    Last Post: 07-19-2013, 04:35 AM
  3. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  4. Macro broken - copy data range column to empty data range column
    By Cascus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2011, 05:20 PM
  5. Replies: 1
    Last Post: 06-17-2006, 09:10 PM

Tags for this Thread

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