Sort Multiple Columns



Sub SortMultipleColumns()
Range("A1:B11").Sort Key1:=Range("A1"), Order1:=xlAscending, _
Key2:=Range("B1"), Order2:=xlDescending, _
Key3:=Range("C1"), Order3:=xlDescending, _
Header:=xlYes
End Sub