Bonjour,
Un essai ...
Sub TrierSurAetE()
Dim sh As Worksheet
Dim Dlig As Long, Dcol As Long
Dim MaFeuil As String
Application.ScreenUpdating = False
MaFeuil = ActiveSheet.Name
For Each sh In ThisWorkbook.Worksheets
sh.Activate
Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Dlig = sh.Cells(Rows.Count, "A").End(xlUp).Row
Dcol = sh.Cells(1, Columns.Count).End(xlToLeft).Column
sh.Sort.SortFields.Clear
sh.Sort.SortFields.Add Key:=sh.Range("A1:A" & Dlig), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
sh.Sort.SortFields.Add Key:=sh.Range("E1:E" & Dlig), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With sh.Sort
.SetRange sh.Range(Cells(1, "A"), Cells(Dlig, Dcol))
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Next sh
Worksheets(MaFeuil).Activate
End Sub
ric