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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com