Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there an easy to sort using 4 keys.... I have sorting using 3 keys
working but cannot get 4 keys to work..... the code I use is: Range(Cells(4, 1), Cells(endrow, 11)).Sort Key1:=Range("F4"), Order1:=xlAscending, Key2:=Range( _ "C4"), Order2:=xlAscending, Key3:=Range("E4"), Order3:=xlAscending, _ header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:= xlTopToBottom this works fine, but if I add a 4th key: Range(Cells(4, 1), Cells(endrow, 11)).Sort Key1:=Range("F4"), Order1:=xlAscending, Key2:=Range( _ "C4"), Order2:=xlAscending, Key3:=Range("E4"), Order3:=xlAscending,Key4:=Range("D4"), Order4:=xlAscending, _ header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:= xlTopToBottom Then I get compilation errors: "Named argument not found" and it highlights "Key4" Thanks Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc. | New Users to Excel | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
Many Sort Keys | New Users to Excel | |||
VBA Sort method w/more than 3 Keys | Excel Discussion (Misc queries) | |||
Dynamically set Sort keys | Excel Programming |