If I use the line of code (not using vba).......
=COUNTIF(R1C1:R36C1,"COUNCIL TAX - General queries")

........ then it works fine.

However if i put this into vba using a macro then it doesn't work.

Application.WorksheetFunction.CountIf(range("R2C1: R35C1"), "COUNCIL TAX
- General queries*")


Totally stuck here,

Will keep trying, but does anyone understand this

Thanks Guys.

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391239

From VBA Help (Range Property):

expression.Range(Cell1)

Cell1 Required. The name of the range. This must be an A1-style
reference in the language of the macro.

So try

Application.WorksheetFunction.CountIf(Range("A2:A3 5"), _
"COUNCIL TAX - General queries*")

In article ,
David494 wrote:

If I use the line of code (not using vba).......
=COUNTIF(R1C1:R36C1,"COUNCIL TAX - General queries")

....... then it works fine.

However if i put this into vba using a macro then it doesn't work.

Application.WorksheetFunction.CountIf(range("R2C1: R35C1"), "COUNCIL TAX
- General queries*")


Totally stuck here,

Will keep trying, but does anyone understand this

Thanks Guys.

Dave

but i just get the same error message.

Compile Error

Expected: =

.....I don't know what this error is.

Thanks for helping

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391239

Strange, it seems to work when I msgBox it.

E.g

MsgBox (Application.WorksheetFunction.CountIf(Range("A2:A 35"), "COUNCIL
TAX - General queries*"))


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391239

Strange, it seems to work when I msgBox it.

E.g

MsgBox (Application.WorksheetFunction.CountIf(Range("A2:A 35"), "COUNCIL
TAX - General queries*"))


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391239

In VBA, if you're not returning the value to a variable or method, you
don't use the parens (see VBA Help "Using Parentheses in Code"), so the
code would be

Application.WorksheetFunction.CountIf Range("A2:A35"), _
"COUNCIL TAX - General queries*"

but that invokes the method without any purpose. Why are you calling
CountIf if you're not going to use the result?

In article ,
David494
wrote:


but i just get the same error message.

Compile Error

Expected: =

....I don't know what this error is.

Sorry for not getting back to you sooner, but i forgot all about this
post. The message box does me fine, as i just want the user to know
the number of times a string appears between two specified dates, then
they can note down this value.

Thanks for your help

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391239