Sub Bouton1_QuandClic()
Dim RgJour As Range
Dim Cel As Range
Set RgJour = Feuil3.Range("I1", Feuil3.Range("I65536").End(xlUp))
For Each Cel In RgJour
If Cel Is Nothing Then Exit Sub
If Cel = "dimanche" Then
Cel.Offset.Clear
Cel.Offset(0, 1).Clear
Cel.Offset(0, -1).Clear
Cel.Offset(0, -2).Clear
Cel.Offset(0, -3).Clear
Cel.Offset(0, -4).Clear
Cel.Offset(0, -5).Clear
Cel.Offset(0, -6).Clear
Cel.Offset(0, -7).Clear
End If
Next Cel
End Sub