Sub tri()
Dim nbLignes As Integer
Worksheets("Feuil1").Range("A2").Select
nbLignes = Range("A2", Selection.End(xlDown)).Cells.Count
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("E2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("D2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("C2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("B2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("A2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Sheets("feuil1").Range("A2:E" & nbLignes)
.Sort Key1:=Sheets("feuil1").Range("D2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
End Sub