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

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

1.	Select entire sheet
2.	Set cell value with For Loop
3.	Use row and column index to reference cell
4.	looping through a worksheet range using a For/Next loop.
5.	Cells.Find: Get Real Last Cell
6.	Get cell value
7.	Sum Cells Based on the Interior Color
8.	Entering a value in the next empty cell
9.	Use the AutoFill function by specifying the destination range
10.	Using Replace Programmatically to Set the Correct Range
11.	Calling CurrentRegion to Inspect a List's Useful Characteristics

Cells(Rows.Count, "A").End(xlUp).Select : Cells « Excel « VBA / Excel / Access / Word