Setting active cell at

[chadski778]

I would like a macro to find the last row that contains data (text) in column A of my spreadsheet and then offseting the active cell 2 rows further down in column A from the last occupied row regardless of how many rows of data there are. Thanks

 

[Scott Huish]

Sub test()
Range("A" & Range("A" & Rows.Count).End(xlUp).Row).Offset(2).Select
End Sub

 

[chadski778]

Thank you that worked!