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