sorting more than four fields

[cmefly]

Hi,

when using the sorting function, u can sort up to three columns in a row. Is there anyway to change that so that i can sort 4 columns????

i've set up the following macro but when i tried adding another "key", i got an error....any ideas???

Selection.Sort Key1:=Range("f13"), Order1:=xlAscending, Key2:=Range("e13"), Order2:=xlDescending, Key3:=Range("f13"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, matchCase:=False, Orientation:= _ xlTopToBottom


any help would be greatly appreciated. Thank you!

 

[just_jon]

Might try sorting a couple of fields, then creating a concatenated field out of those 2; then you can sort on that field and 2 others.

 

[cmefly]

perfect!!

thank you very much for your speedy reply!

 

[Juan Pablo González]

You can also look here:

http://www.mrexcel.com/board2/viewtopic.php?t=68008&highlight=sort+three