How can I find last row that contains data

Y

YN49061

New member
Joined
Jul 31, 2014
Messages
2
Reaction score
0
Points
0
Location
Saudi Arabia
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,
 
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).
 
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,
 
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
 
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
 
You must log in or register to reply here.
Back
Top