What is Wrong with This?

  • Thread starter Thread starter Tod
  • Start date Start date
T

Tod

Sub Test()
a = WorksheetFunction.CountIf(Range("tim").Range("jeifh", "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("jeifh",
"sdipriep", "tim", "jppks"))

isabelle

Le 2013-12-23 18:13, Tod a écrit :
 
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("jeifh",
"sdipriep", "tim", "jppks"))

isabelle

Le 2013-12-23 18:13, Tod a écrit :
 
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("jeifh",
"sdipriep", "tim", "jppks"))

isabelle

Le 2013-12-23 18:13, Tod a écrit :
 
Back
Top