Function NbreCellulesCouleurVisible(Plage As Range, couleur As Byte) As Long
Application.Volatile
Dim Cellule As Range
For Each Cellule In Plage
If Cellule.Interior.ColorIndex = couleur And Not IsEmpty(Cellule) And Cellule.EntireRow.Hidden = False _
Then NbreCellulesCouleurVisible = NbreCellulesCouleurVisible + 1
Next Cellule
End Function