sorting limitation

[bradley7]

is there a sorting limit in excel, i want 4 keys?

Range("A1:O" & NoOfRawRows).Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range _
("B1"), Order2:=xlAscending, Key3:=Range("C1"), Order3:=xlAscending, _
Key4:=Range("D1"), Order4:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _
DataOption2:=xlSortNormal, DataOption3:=xlSortNormal, DataOption4:=xlSortNormal

 

[Jay Petrulis]

Yes. Three is the sort field limit until the next version of Excel.

Workaround: Sort twice. First, sort on the least critical (4th key). The do another sort with your other three key fields.