You need to do two sorts. First sort on the least significant
columns (typically the right-most columns) then sort on the most
significant columns (typically the left-most columns).
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"DCSwearingen"
wrote
in message
news:DCSwearingen.29azmo_1150139405.5059@excelforu m-nospam.com...
I know I have seen a similar question, but I did a search for
"Sorting
Multiple Criteria" and did not find what I am looking for.
Is there a way to use VBA to sort by more than three criteria?
Specifically four criteria...
Example: The Header row is row 2
Selection.Sort _
Key1:=Range("E2"), Order1:=xlAscending, _
Key2:=Range("H2"), Order2:=xlAscending, _
Key3:=Range("B2"), Order3:=xlAscending, _
Header:=xlNo, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
What the operators would like is
Selection.Sort _
Key1:=Range("A2"), Order1:=xlAscending, _
Key2:=Range("E2"), Order2:=xlAscending, _
Key3:=Range("H2"), Order3:=xlAscending, _
Key4:=Range("B2"), Order3:=xlAscending, _
Header:=xlNo, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
but this creates errors
--
DCSwearingen
Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile:
http://www.excelforum.com/member.php...o&userid=21506
View this thread:
http://www.excelforum.com/showthread...hreadid=551157