Correction :
Sub Comptage()
'Compte les caractères non numériques dans une formule
Dim Boucle As Long, Chaine As String, Car As String, NbNum, lig As Variant
NbNum = 0
Numer = 0
For lig = 1 To Range("A65535").End(xlUp).Row
Chaine = CStr(Range("A1").Offset(lig - 1, 0).Formula)
For Boucle = 1 To Len(Chaine)
Car = Mid(Chaine, Boucle, 1)
If IsNumeric(Car) = False Then
If Car <> "." And Car <> "," Then
NbNum = NbNum + 1
Else
Numer = 1
End If
End If
Next Boucle
If NbNum = 0 And Numer = 1 Then NbNum = 1
Range("B1").Offset(lig - 1, 0).Value = NbNum
NbNum = 0
Numer = 0
Next lig
End Sub