how to jump to the last used row of data

[traildoc]

I need a simple way to go to column A of the last data entry for any cell in a spreadsheet

 

[jasonb75]

Is Ctrl + End, Home simple enough?

 

[Rick Rothstein]

I need a simple way to go to column A of the last data entry for any cell in a spreadsheet

In VB code?

For last displayed value
--------------------------
LastUsedRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row
 
For last value or formula (even if displaying empty string "")
--------------------------------------------------------------------
LastUsedRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row