Bonjour
Comme je ne comprends pas tout ce que je fais
Essayes
Sub classement()
Dim Plage As Range
Dim Lig&, lgn&, Nom As String
Application.ScreenUpdating = False
On Error Resume Next
Rows.Ungroup
On Error GoTo 0
Rows.Hidden = False
lgn = Range("A" & Rows.Count).End(xlUp).Row
Nom = ActiveSheet.Name & "Tableau1"
Set Plage = Range("A11:F" & lgn)
On Error Resume Next
ActiveSheet.ListObjects.Add(xlSrcRange, Plage, , xlYes).Name = Nom
On Error GoTo 0
With ActiveWorkbook.ActiveSheet.ListObjects(Nom).Sort
.SortFields.Clear
.SortFields.Add Key:=Range("A11"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
.SortFields.Add Key:=Range("B11"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Header = xlYes
.Apply
End With
ActiveSheet.Range("A11:F" & lgn).Interior.Pattern = xlNone
For Lig = Range("A" & Rows.Count).End(xlUp).Row To 11 Step -1
If Cells(Lig, 1) = Cells(Lig - 1, 1) Then Rows(Lig).Rows.Group
Next Lig
ActiveSheet.Outline.ShowLevels RowLevels:=1
Application.ScreenUpdating = True
End Sub