Assign Formula Result to variable

[Kenneth Hobs]

I am not a fan of R1C1 notation normally.
[VBA]Debug.Print Evaluate("=COUNTA(Main!B3:K3)")[/VBA]
Of course it will error if the worksheet named Main does not exist.