+ Reply to Thread
Results 1 to 6 of 6

Finding the value from a last used cell in Column

  1. 11-02-2016, 01:12 PM #1
    subbby
    subbby is offline
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Finding the value from a last used cell in Column

    Hello,

    I have a column A full of values.

    How do I have a code that finds the value from the last used cell in that column ?

    On an excel sheet, 
    Please Login or Register  to view this content.
    this formula gave me what I want. Not sure how to implement this in a vba code.

    Tried adding .worksheetfunction prior to Lookup, but got an error 400

    Any help is much appreciated.

    -Subbby
    Last edited by subbby; 11-02-2016 at 01:21 PM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 11-02-2016, 01:17 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding the value from a last used cell in Column

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-02-2016, 01:21 PM #3
    subbby
    subbby is offline
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Finding the value from a last used cell in Column

    Wonderful.. that worked.. Thanks...

    Added a Reputation Star
    Reply With QuoteRegister To Reply
  4. 11-02-2016, 01:31 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding the value from a last used cell in Column

    You're welcome. Glad to help out and thanks for the feedback.
    Reply With QuoteRegister To Reply
  5. 11-02-2016, 02:14 PM #5
    subbby
    subbby is offline
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Finding the value from a last used cell in Column

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.

    Curious to know what does that 3 stand for?
    Reply With QuoteRegister To Reply
  6. 11-02-2016, 02:30 PM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Finding the value from a last used cell in Column

    It a global constant for xlUp - means the same as End(xlUp) which you've probably seen many times.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding the last cell in a column
    By springboardjg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 07:47 AM
  2. Finding the last cell in a column based on cell contents
    By carlito_1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2011, 05:06 AM
  3. Finding a Cell Using Row and Column
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2010, 04:47 PM
  4. [SOLVED] Finding the first cell in column where value <> 0
    By WannaBeExceller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 11:55 PM
  5. [SOLVED] Finding the first cell in column where value <> 0
    By WannaBeExceller in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 03:55 PM
  6. Finding the last non bank cell in a column
    By Andrew B in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2005, 07:05 AM
  7. [SOLVED] Finding Cell Interior Colour of First Cell in Column
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2005, 11:06 PM
  8. Finding column of a particular cell
    By Prema in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-07-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1