Sub compterOngletsPartie()
Dim x As Integer
Dim j As Integer
Dim s As String
j = 0
For Each Worksheet In Worksheets
If Worksheet.Name [COLOR=Red][B]Like [/B][/COLOR]"Partie*" Then
j = j + 1
Else
j = j - 1
End If
Next
If j > 1 Then
s = "s"
Else
s = ""
End If
MsgBox "Il y a " & j & " feuille" & s & " CIP"
End Sub