Hi,

LastRow = Cells(Cells.Rows.Count,"A").End(xlUp).Row
would give you the integer representing the last row used in column A

LastRowValue = Cells(LastRow,1).Value
would give you the Value of the last cell in column A ( 1 represents
first column, i.e A )

HTH
Cheers
Carim