Results 1 to 5 of 5

Thread: How can I find last row that contains data

  1. #1
    Neophyte YN49061's Avatar
    Join Date
    Jul 2014
    Location
    Saudi Arabia
    Posts
    2
    Articles
    0

    How can I find last row that contains data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Sir/Madam,

    We have an excel 97-2003 worksheet that has been develop since last 1994. This excel use as a monitoring of management of change in the plant, whether it is a permanent change or temporary change. I have been assign to mointor in daily basis of any updates from the team. Now since there were 2,000 plus records that has been saved.

    Instead of scrolling down to see the last row for additional data, I am planning to develop a simple button that looks go through to the last row that contains the data.

    Currently, the IT team has completed the new migration of Excel 2010 to 2013.

    I am fairly new to excel programming, however, I am willing to learn more excel knowledge base.

    Can any one help me please to complete this interest.

    Regards,

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    Do you really need a button?
    Try selecting any cell in the column you want to find the bottom of, then double-click on the bottom border of that cell (avoiding the little black square in the bottom right of that cell).

  3. #3
    Neophyte YN49061's Avatar
    Join Date
    Jul 2014
    Location
    Saudi Arabia
    Posts
    2
    Articles
    0
    Dear p45cal,

    Apologize of my late reply as the moment you replied on I was already went home for week ends (Fri & Sat). Your recommendation is definitely correct. No need to develop a button.

    Appreciate your kind assistance. Thanks

    Regards,

  4. #4
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    You can do this with a formula...

    Code:
    =HYPERLINK("#"&CELL("Address",INDEX(A:A,COUNTA(A:A))),"Last Row")
    Change the A:A reference for the column of your choice.

    HTH
    Regards,
    Zack Barresse

  5. #5
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    374
    Articles
    0
    Excel Version
    2020
    You can insert a hyperlink in cell A1 once, using

    Code:
    Sub tst()
        Hyperlinks.Add Sheet1.Cells(1), "", Cells(Rows.Count, 1).End(xlUp).Address
    End Sub
    You can update the hyperlink with

    Code:
    Private Sub Worksheet_Activate()
        Hyperlinks(1).SubAddress = Cells(Rows.Count, 1).End(xlUp).Address
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •