Results 1 to 4 of 4

Thread: Get last Filled Cell address in a Range.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-24-2012, 12:09 AM #1
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Assume there are values in A1, A2, A3, B1 and C1... which is the last filled cell? Your formula says C3 but I can make a strong case (at least in my own mind) for A3 being the better answer (last filled cell on the last row of data). Your thoughts?
    Last edited by Rick Rothstein; 03-24-2012 at 12:36 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Reference A Cell Conditionally Using ADDRESS And INDIRECT Functions
    By mahmoud-lee in forum Excel Help
    Replies: 15
    Last Post: 06-04-2013, 07:02 PM
  2. Replace Pivot Table Source Range with New Address VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 04-25-2013, 07:51 PM
  3. Change in One Cell that Prompts Email to Address in Adjacent Cell
    By jtroi89 in forum Excel Help
    Replies: 1
    Last Post: 08-21-2012, 07:36 PM
  4. Last Filled Cell Having Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 07-18-2011, 02:33 PM
  5. Get Range Address When Length Of Address Greater than 251 / 255
    By Rasm in forum Excel Help
    Replies: 6
    Last Post: 04-03-2011, 09:46 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
  •  

Forum Rules