my macro is remembering specific range instead of 1st to last

[Pam @ Joyce]

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

 

[Mike H]

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

 

[DS]

Hi Pam,

This selects from Cell A1 to the last entry in Col A, in the same way as
selecting A1, then pressing SHIFT+CTRL+DOWN ARROW.

Range(Range("A1"), Range("A1").End(xlDown)).Select

HTH
DS

 

[Pam @ Joyce]

Thank you so much Mike - this has done the trick.