| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - specific range | Excel Discussion (Misc queries) | |||
| How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
| How to stop Excel remembering/loading macro from previously opened Workbook | Excel Programming | |||
| Macro to Specific Cells in a Range | Excel Programming | |||
| macro that sumif a specific range | Excel Programming | |||
Linear Mode
