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