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

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

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

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

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

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" 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

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

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

"Mike H" wrote:

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