Can you sort by more than 3 cryteria?

[Barbarte]

Hi everyone,

with code like this:

    Cells.Select
    Selection.Sort Key1:=Range("G2"), Order1:=xlAscending, Key2:=Range("M2") _
        , Order2:=xlAscending, Key3:=Range("H2"), Order3:=xlAscending, Header:= _
        xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
        xlSortNormal

can you add a 4th parameter by adding in:

Key4:=Range("I2"), Order4:=xlAscending,

so it looks like this:

Cells.Select
    Selection.Sort Key1:=Range("G2"), Order1:=xlAscending, Key2:=Range("M2") _
        , Order2:=xlAscending, Key3:=Range("H2"), Order3:=xlAscending-
        , Key4:=Range("I2")  ,Order4:=xlAscending,Header:= _
        xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
        xlSortNormal

will that work?
if not, is there another way to do it?

Thanks

 

[Barbarte]

Nope, in excel 2002 you can't, it's limited to 3.
In the latest version of excel you can do as many as you like.

 

[RoryA]

In earlier versions, you have to do multiple passes, so you sort by the three least important first, then sort by the next 3 least important and so on. That way they should all end up in the right order. In your case, you could sort on fields 2,3 and 4 then do another sort on 1.

 

[Barbarte]

Thanks!