VBA Sort multiple columns

[maclachlan19]

I'm trying to run some code to sort multiple columns at once. I get an error:
Compile error: Named argument not found

Range("Managers").Sort Key1:=Range("Q4"), Order1:=xlDescending, _
                        Key2:=Range("G4"), Order2:=xlDescending, _
                        Key3:=Range("H4"), Order3:=xlAscending, _
                        Key4:=Range("F4"), Order4:=xlDescending, _
                        Key5:=Range("I4"), Order5:=xlAscending, _
                        Header:=xlYes

 

[Fluff]

It should be .Sort not ,Sort

 

[maclachlan19]

This is now working, thanks Guys
Here is the final code for others searching this thread.

With Range("Managers")
    .Sort key1:=Range("I4"), Order1:=xlAscending, Header:=xlYes
    .Sort key1:=Range("F4"), Order1:=xlDescending, Header:=xlYes
    .Sort key1:=Range("H4"), Order1:=xlAscending, Header:=xlYes
    .Sort key1:=Range("G4"), Order1:=xlDescending, Header:=xlYes
    .Sort key1:=Range("Q4"), Order1:=xlDescending, Header:=xlYes
End With