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

  • Thread starter Thread starter Pam @ Joyce
  • Start date Start date
P

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
 
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
 
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
 
Back
Top