Sub tri()
Application.ScreenUpdating = False
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Recherche").Sort.SortFields.Clear
With Sheets("Recherche").Sort
.SetRange Range("A2:E43")
.SortFields.Add Key:=Range("B2"), Order:=xlAscending
.Apply
End With
Application.ScreenUpdating = True
End Sub