Sub Tri()
Application.ScreenUpdating = False
Columns(4).Insert 'insère une colonne auxiliaire
With Range("D1:D" & Cells.SpecialCells(xlCellTypeLastCell).Row)
.Formula = "=Ext(E1)"
.Value = .Value 'supprime les formules
.EntireRow.Sort .Cells, xlAscending, Header:=xlYes 'tri
.EntireColumn.Delete 'supprime la colonne auxiliaire
End With
End Sub
Function Ext(x$) As String
Dim s
s = Split(x)
If UBound(s) > 2 Then Ext = s(3)
End Function