| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns with macros
I'm using the code below to sort the Sheet1 cells in range
of A10 to C30. I'll always want the range to start at A10, but right and bottom boundaries of the range may change. Is there a way where you can specify the range from A10 to "the end" of the worksheet? Worksheets("Sheet1").Range("A10:C30").Sort _ Key1:=Worksheets("Sheet1").Range("A10") Thanks, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros for sorting data | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| sorting with macros | Excel Discussion (Misc queries) | |||
| Sorting columns with macros | Excel Programming | |||
| help with dataform and sorting macros | Excel Programming | |||
Hybrid Mode
