Hi
I have to sort the data in my excell sheet. I have to sort my data using 4
keys.
Excell sort functios allows sorting by 3 values.
I tried writing a VBA code but it only excepts 3 keys.
Worksheets("sheet").Range("a1:ba67").Sort _
Key1:=Worksheets("sheet").Range("c1"), order1:=xlAscending, _
Key2:=Worksheets("sheet").Range("e1"), order1:=xlAscending, _
Key3:=Worksheets("sheet").Range("f1"), order1:=xlAscending

Is it possible to sort using 4rth key also.

Thanks in advance.