1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Sub triertableau()
Dim i As Integer
For i = 4 To 300 Step 1
Worksheets("Feuil1").Sort.SortFields.Add Key:=Range("J" & i, "J" & i), SortOn:=xlSortOnValues, Order:=xlAscending
Worksheets("Feuil1").Sort.SortFields.Add Key:=Range("H" & i, "H" & i), SortOn:=xlSortOnValues, Order:=xlAscending
Worksheets("Feuil1").Sort.SortFields.Add Key:=Range("G" & i, "G" & i), SortOn:=xlSortOnValues, Order:=xlAscending
Worksheets("Feuil1").Sort.SortFields.Add Key:=Range("F" & i, "F" & i), SortOn:=xlSortOnValues, Order:=xlAscending
Worksheets("Feuil1").Sort.SortFields.Add Key:=Range("D" & i, "D" & i), SortOn:=xlSortOnValues, Order:=xlAscending
With ActiveWorkbook.Worksheets("Feuil1").Sort
.SetRange Range("A" & i, "O" & i)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Next i
End Sub |
Partager