| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selection
I need help with a macro that expands the selection from the ActiveCell to
the last populated cell in the same column. For example: if Cell A10 is the last populated cell in column A, and the ActiveCell is A2, i want the macro to expand the selection to be from A2 to A10. The active cell will not necessarily be in column A. So i want the macro to be valid for use on any column. I'm using Excel 2003. Many thanks Tendresse |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot expand the selection to entire spreadsheet when sorting | Excel Worksheet Functions | |||
| Prevent SORT from asking to expand selection in Excel 2007? | Excel Discussion (Misc queries) | |||
| Expand Selection in Auto filter | Excel Worksheet Functions | |||
| Expand Selection in Multiple Sheets | Excel Discussion (Misc queries) | |||
| Shift+Arrow does not expand selection | Excel Discussion (Misc queries) | |||
Threaded Mode
