Array Formula Using WorksheetFunction

There's a post by this same title here: https://www.excelforum.com/excel-pro...tfunction.html

I couldn't get this to work at all for me. I'm not clear on where the result is returned in a vba line like the following:
ActiveSheet.Evaluate = "=1+1"

The error is something like "couldn't get the evaluate property..."

The formula in the post was:
Activesheet.Evaluate = "=COUNT(IF(Location=""NY"",IF(Headcount,1)))"

In my case, I'm trying to do the equivalent of =MATCH("TextText",B:B&C:C,0) in VBA. I'm not sure if the array aspect (have to use ctrl-shift in a worksheet) is an issue here or not since it's returning a single value. If not, then the above referenced post is not relevant here.

The code I tried to use is:
WorksheetFunction.Match("TextText", Range("B:B&C:C"), 0)

and I get the error that the Range method failed. Is this kind of thing just beyond the scope of the worksheet functions?