| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORT: Is it possible to supply operands via function / vba sub
I got the range wrong. Below is the correction.
Worksheets("sheet1"). _ Range(target).Sort _ Key1:=Worksheets("sheet1").Columns(mykey1), _ Key2:=Worksheets("sheet1").Columns(mykey2), _ Key3:=Worksheets("sheet1").Columns(mykey3), _ Header:=xlNo, DataOption1:=xlSortNormal "Mike Iacovou" wrote: thanks joel i'll give that a try. cheers. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-ins query wizard operands (criteria tab) | Excel Discussion (Misc queries) | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Weeks of Supply Function | Excel Worksheet Functions | |||
| custom toolbar for operands | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Hybrid Mode
