hi Todd,

putting a comma instead a point

a = WorksheetFunction.CountIf(Range("tim"),Range("jeif h",
"sdipriep", "tim", "jppks"))

isabelle

Le 2013-12-23 18:13, Tod a écrit :
Sub Test()
a = WorksheetFunction.CountIf(Range("tim").Range("jeif h",
"sdipriep", "tim", "jppks"))
MsgBox a
End Sub

I'm getting a compile error.

Thanks
Todd