Sub EffaceDate()
Dim cellule As Range
Dim rngETDprevue As Range
Set rngETDprevue = Sheets("PS").Range("Tableau1[Date]")
Application.ScreenUpdating = False
rngETDprevue.Select
For Each cellule In rngETDprevue
If cellule = 7 Then cellule.ClearContents
If cellule = "#VALEUR!" Then cellule.ClearContents
Next cellule
Application.ScreenUpdating = True
End Sub