VBA How to Sort Cells and Ranges

Recommended method with one criteria and Header included in the Range​

Range("A1:D20").Sort _
Key1:=Range("A1"), Order1:=xlAscending, _
Header:=xlYes

Recommended method with two criteria and Header included in the Range

Range("A1:D20").Sort _
Key1:=Range("A1"), Order1:=xlAscending, _
Key2:=Range("B1"), Order1:=xlAscending, _
Header:=xlYes

Recommended method for partial ranges with one criteria and Header not included in the Range

Range("O25:S40").Sort _
Key1:=Range("P:P"), Order1:=xlAscending, _​​
Header:=xlNo

Recommended method for partial ranges with two criteria and Header not included in the Range​

Range("O25:S40").Sort _
Key1:=Range("P:P"), Order1:=xlAscending, _​​
Key2:=Range("R:R"), Order1:=xlDescending, _
Header:=xlNo
Subscribe
Subscribe