With ActiveSheet
lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With

will give you the last filled row in Col A on the active sheet...

"garygc" wrote:

How do I build a macro to select a cell after the last cell in a column with
data, that will work when the number of rows in a worksheet changes from
worksheet to worksheet?