Using countif function across workbooks

Hi,
First time post here.

I'm new to VBA and must be doing something simple wrong here.

I need to use a COUNTIF function in VBA across two workbooks (it needs to be a function in VBA- I can't just type the formula in Excel because I use variables within the filename from which I take the range).

So the range is within the workbook starting "MStoGTR", within Col C of sheet "SCB_ACKd".
The criteria is in the active sheet, one cell to the left (FYI: I plan to later drag the COUNTIF down in that column).

Thanks in advance!
Rich

Please Login or Register  to view this content.

Hi FDibbins
Thanks for your reply. I'm new to VBA so still trying to understand the functions, so really appreciate the help!
I know you can use countif across worksheets and workbooks as a formula in Excel - are you 100% sure you can't do the same in VBA?
Thanks again.

Thanks Josie. Sorry to be a pain, but when I use your code I receive:

Compile error:
Expected: =

Am I missing a "=" sign somewhere?