Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello ppl,
Please help to simplify my following macros. The sorting event should be in order and must not be loop. Sub MultiColumn_Sorting() Application.screenupdating = false Range("A3:U52").Select Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("A3"), Order2:=xlDescending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("Q3"), Order2:=xlDescending, _ Key3:=Range("R3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("P3"), Order2:=xlDescending, _ Key3:=Range("Q3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("O3"), Order2:=xlDescending, _ Key3:=Range("P3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("N3"), Order2:=xlDescending, _ Key3:=Range("O3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("M3"), Order2:=xlDescending, _ Key3:=Range("N3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("L3"), Order2:=xlDescending, _ Key3:=Range("M3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("K3"), Order2:=xlDescending, _ Key3:=Range("L3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Selection.Sort _ Key1:=Range("X3"), Order1:=xlDescending, _ Key2:=Range("J3"), Order2:=xlDescending, _ Key3:=Range("K3"), Order3:=xlDescending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple question on Sorting | Excel Discussion (Misc queries) | |||
automatically sorting a simple list | Excel Discussion (Misc queries) | |||
MultiColumn ComboBox | Excel Programming | |||
display multicolumn box | Excel Programming | |||
Multicolumn Combo Box | Excel Programming |