Option Explicit
Sub True_supprimer()
Dim c As Range, maxi As Long
With Application: .ScreenUpdating = False: .Calculation = xlManual: .EnableEvents = False: End With
Rows("1:2").Insert
For Each c In Rows("3:3").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeConstants)
c.Offset(-2, 0).FormulaR1C1 = "=COUNTIF(R[3]C:R[40]C,""true"")"
c.Offset(-1, 0).FormulaR1C1 = "=COUNTA(R[1]C:R[229]C)-1"
Next
maxi = Application.Max(Rows("2:2"))
For Each c In Rows("1:1").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeFormulas)
If c.Value = maxi Then c.Offset(3, 0).Resize(1000000).Clear
Next
Rows("1:2").Delete
With Application: .EnableEvents = True: .Calculation = xlAutomatic: .ScreenUpdating = True: End With
End Sub