Sub SupprimeColonnes()
Dim v, c As Range, sup As Range
v = 300 'modifiable
For Each c In ActiveSheet.UsedRange.Rows(1).Cells
If c = v Then Set sup = Union(c, IIf(sup Is Nothing, c, sup))
Next
If Not sup Is Nothing Then sup.EntireColumn.Delete
End Sub
Sub supression()
For i = Range("IV1").End(xlToLeft).Column To 1 Step -1
If Cells(1, i) = 300 Then Columns(i).Delete Shift:=xlToLeft
Next i
End Sub