Sub Bouton1_QuandClic()
Dim ws As Worksheet
Dim c As Range
For Each ws In Worksheets
For Each c In ws.UsedRange
If c.Interior.ColorIndex = 6 Then
c.ClearContents
End If
Next c
Next ws
End Sub
Sub Bouton1_QuandClic()
Dim ws As Worksheet
Dim c As Range
For Each ws In Worksheets
For Each c In ws.UsedRange
With c.Interior
.ColorIndex = IIf(.ColorIndex = 6, xlNone, .ColorIndex)
End With
Next c
Next ws
End Sub
Sub Bouton1_QuandClic()
Dim c As Range
For Each c In Sheets("Feuil1").UsedRange
If c.Interior.ColorIndex = 6 Then
c.ClearContents
End If
Next c
End Sub
Sub Bouton1_QuandClic()
Dim C As Range
For Each C In[B] Sheets("Feuil1")[/B].UsedRange
With C.Interior
.ColorIndex = IIf(.ColorIndex = 6, xlNone, .ColorIndex)
End With
Next C
End Sub