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