1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Sort Multiple Columns

[Solved] Vba Sort Multiple Columns | Vb - Code Explorer | yomemimo.com
Question : vba sort multiple columns

Answered by : vastemonde

' 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

Source : | Last Update : Mon, 25 Jan 21

Answers related to vba sort multiple columns

Code Explorer Popular Question For Vb