Hi,

This will select the used range in column A

lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("A1:A" & lastrow).Select

Mike

"Pam @ Joyce" wrote:

I need my macro to include shift+end+down arrow to select from 1st to last in
a column, as the spreadsheet grows it only remembers the specific range.
what do I need to do to have it select from 1st to last in a column? Can
someone help pls