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

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

That still does not work. Compile error?
Thanks


"isabelle" wrote in message ...

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

Never mind. I did not realize that CountIf and Range functions are called
from ActiveSheet.
thanks

"isabelle" wrote in message ...

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