Sub DecocheCheckBox()
Dim CB As Excel.CheckBox
Dim S As Worksheet
Dim i&
Dim col&
Set S = ActiveSheet
For i& = 1 To S.CheckBoxes.Count
Set CB = S.CheckBoxes(i&)
col& = CB.TopLeftCell.Column
If col& = 5 Or col& = 6 Then CB.Value = False
Next i&
End Sub
Sub decoche()
Dim i As Integer
i = 6
While i < 200
Worksheets("feuil1").Range("E" + CStr(i)).Select
Selection.Value = False
Worksheets("feuil1").Range("F" + CStr(i)).Select
Selection.Value = False
i = i + 1
Wend
End Sub
" erreur d'exécution '1004' :
La méthode select de la classe Range a échoué
PMO2, j'essaye ton code