Sub Efface_II()
Dim p As Range
With ActiveSheet
T = .[B9:B1091].Value: Set p = .Cells(9, .Columns.Count).Resize(3 * 361)
p.FormulaR1C1 = "=IF(RC2=8,""$"",0)": p.SpecialCells(-4123, 2).Offset(, -Columns.Count + 2) = ""
.Columns(.Columns.Count).Clear
End With
End Sub