Sub t_asc()
Dim p As Range
Set p = Range("A1:C7")
tri p, xlYes, xlAscending, xlAscending
End Sub
Sub t_desc_light()
Dim p As Range
Set p = Range("A1:C7"): tri p, 1, 2, 2
End Sub
Private Sub tri(p As Range, titre As XlYesNoGuess, sA As XlSortOrder, sB As XlSortOrder)
p.Sort Key1:=p(1)(1), Key2:=p(2)(1), Header:=titre, Order1:=sA, Order2:=sB
End Sub