Sub ote_zero()
Dim plg As Range
Set plg = Application.InputBox _
("Sélectionner une cellule", , , , , , , 8)
mavariable = plg.Address
'MsgBox mavariable
Range(mavariable).SpecialCells(xlCellTypeConstants, 1).Select
For Each cellule In Selection
If cellule.Value = 0 Then cellule.Clear
Next
[A1].Activate
End Sub