Button to find last record

Hi all

I have a spreadsheet with lots of data in columns and rows. I need to create a button that when users click, it will take them to the last record on the sheet. Is this possible?

Thanks

put a command button on sheet from the control tool box
(if you cant see it right click tool bar and check control tool box option)
right click it
view code
put this in

Private Sub CommandButton1_Click()
'LastCellInColumn

Range("A65536").End(xlUp).Select

End Sub

click file and exit to excel
rigt click button again
click comand button object
edit name of button
then on control tool box tool bar click the triangle thingy on the left side to exit design mode
now cllicking button will go to last used row in col A

The coding works perfectly. Thank you very much