With [Nicotine]
If .ListObject.DataBodyRange.Rows.Count = 1 Then
If .Cells(1, 16) = 0 Then .ListObject.DataBodyRange.Delete: Exit Sub
Else
.Columns(18).EntireColumn.Insert ' colonne auxiliaire
.Columns(18) = "=1/(RC[-2]=0)" ' RC[-2] : Nb Colonne(s) avant Colonne Auxiliaire = (la colonne cible à traiter) --> "Q"
.Sort .Columns(18), xlDescending, Header:=xlYes ' tri pour accélérer
Intersect(.Columns(18).SpecialCells(xlCellTypeFormulas, 1), .Cells).EntireRow.Delete xlUp
.Columns(18).Delete ' Supprimer la colonne
End If
End With