First non-blank row in WS after hyperlinking

[Jack Deuce]

I have several ws I use as check registers. I'd like to be able to go
to the last non-blank row in that ws when I click that register's ws
from the index page. It would always be the next available row in the
applicable ws. Is there a way from HYPERLINK to do that or maybe a
function once I get there? Macro?

TIA

 

[ryguy7272]

here are a couple different ways:

this will select the cell. it's not a good practice to select, but just used
as
an illustration here.

range(worksheets("Sheet1").cells(rows.Count,"A").end(xlup).address).Select


Sub FindLastCell1()
Cells(Rows.Count, "A").End(xlUp).Select
End Sub

You can record a macro, hit ctrl+down arrow key and look at the code. Good
learning experience!