What is Wrong with This?

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
 
I

isabelle

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 :
 
T

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("jeifh",
"sdipriep", "tim", "jppks"))

isabelle

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

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("jeifh",
"sdipriep", "tim", "jppks"))

isabelle

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Remove Identical words 0
How to make macros work in both XL2003 and XL2010?!? 2
Not getting "argument type mismatch" 4
Prompt For Replace in Selection And More... 0
Word VBA Copy Heading and Content 4
passing cell address to sub - write that cell 2
Sum a variable length column 1

Top