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.