| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VBA, Excel - Find Range, Sort
Please correct my macro:
Application.Goto Reference:="AAA" ActiveCell.Resize(xlDown, 9).Select I'm trying to write a macro to find a named range, then highlight the rows (?) down to the last cell and to the right (col) 9 columns so I can sort it ascending (header is AAA). I can copy the macro for the sorting by doing it step by step but I don't know how select the range. Thanks you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort range changes during sort | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
| How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions | |||
Threaded Mode
