Full Version: Search for strings
UtterAccess 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 UA. To view the full version with more information, formatting and images, please click here.