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

32 votes533 views2 answers
Excel vba column letter
VBA
1 vote232 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote247 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote231 views1 answer
Excel named range sum
VBA
2 votes213 views2 answers
Constructor vb.net
VBA
0 vote212 views1 answer
Excel vba disable alerts
VBA
0 vote236 views1 answer
Vba count all row
VBA
1 vote226 views1 answer
Excel vba close form escape key
VBA
0 vote226 views2 answers
Excel vba close without saving
VBA
1 vote252 views1 answer
Vba loop through files in folder
VBA