1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
Dim Nb_Lignes As Integer
Nb_Lignes = Range("A65536").End(xlUp).Row
'Sélection des lignes à trier
Range("A2:O" & Nb_Lignes).Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, _
Key2:=Range("B2"), Order2:=xlAscending, _
Key3:=Range("C2"), Order3:=xlAscending, _
Key4:=Range("D2"), Order4:=xlAscending, _
Key5:=Range("E2"), Order5:=xlAscending, _
Key6:=Range("F2"), Order6:=xlAscending, _
Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:=xlSortNormal, _
DataOption4:=xlSortNormal, DataOption5:=xlSortNormal, DataOption6:=xlSortNormal |
Partager