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