Vba sort multiple columns

' Sorts a range with multiple criterias
Sub MultipleColumnsSort()
    With ActiveSheet.Sort
         .SetRange Range("A1:D10")
         .SortFields.Add Key:=Range("A1"), Order:=xlAscending
         .SortFields.Add Key:=Range("B1"), Order:=xlDescending
         ' If range includes headers
         .Header = xlYes
         .Apply
    End With
End Sub

Similar codes

5 votes260 views1 answer
Excel vba last byte from INTEGER
VBA
1 vote253 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
2 votes235 views1 answer
Vba split string
VBA
0 vote229 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote239 views1 answer
Vba get workbook name
VBA
0 vote234 views1 answer
Vba sheet visible
VBA
0 vote242 views1 answer
Excel vba calculate
VBA
0 vote247 views4 answers
How to continue formula in below line in vba code
VBA
0 vote243 views1 answer
Excel vba join variant array
VBA
0 vote212 views1 answer
Excel vba open browser
VBA