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

0 vote325 views1 answer
Get current year vb
VBA
0 vote322 views1 answer
Enable macros on opening workbook vba
VBA
1 vote268 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote319 views1 answer
VB Error Code BC30201
VBA
0 vote306 views1 answer
Vba word open document read only
VBA
0 vote321 views1 answer
How to set location and size of new from vb
VBA
1 vote327 views1 answer
Vba optional
VBA
20 votes457 views1 answer
Excel vba recursive example factorial function
VBA
0 vote304 views1 answer
Visual basic msdos
VBA
3 votes317 views1 answer
Excel vba get the workbook full file name with path
VBA