Bonjour,
Essaie ceci :
Public Sub SortData()
Dim TD As Range, lCol As Long
lCol = 18
Set TD = ActiveSheet.Cells(8, 1).CurrentRegion
TD.Sort key1:=TD.Cells(1, lCol), order1:=xlDescending, Header:=xlYes
'TD.AutoFilter field:=lCol, Criteria1:=30, Operator:=xlTop10Items
End Sub
Si le tri ne convient pas, remplacer xlDescending par xlAscending.
Cdlt.