Full Version: Search for strings
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
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.

i just put this out to a msgbox and it seems to work fine now
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.