Bonjour
je ne comprends pas pourquoi excel me demande une attendu a la fin de end sub
Sub heure()
Dim h, i As Integer
With Worksheets("graphique")
For h = 57 To 51
If .Cells("C", h) < .Cells("r", 51) Then
ThisWorkbook.Worksheets("activite").Cells("b12").Interior.Color = RGB(128, 255, 128)
Else
ThisWorkbook.Worksheets("activite").Cells("b12").Interior.Color = RGB(254, 195, 172)
End If
Next h
With Worksheets("graphique")
For i = 57 To 51
If .Cells("F", i) < .Cells("r", 51) Then
ThisWorkbook.Worksheets("activite").Cells("b13").Interior.Color = RGB(128, 255, 128)
Else
ThisWorkbook.Worksheets("activite").Cells("b13").Interior.Color = RGB(254, 195, 172)
End If
Next i
End Sub
merci