Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is Wrong with This?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is Wrong with This?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is Wrong with This?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is Wrong with This?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What do I do wrong [Excuses pushing the wrong key combination earlier] | Excel Programming | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
What am I doing wrong? | Excel Programming | |||
What am I doing wrong? | Excel Programming | |||
what went wrong?! | Excel Programming |