Insert CountIf Formula using VBA

[sparky2205]

Folks,
I'm trying to enter a dynamic COUNTIF formula in a cell using vba. I don't want the result of the formula. I want to enter the formula itself.
This is the basis of what I've been playing around with:

Range("F4").Formula2="CountIf($B$9:$B$"&LastRow&"),"<>n/a")"

This gives me the "Expected: end of statement" error.
I've tried a few variations, most of which return the error above, one of which returned an "invalid character" error.

I've successfully inserted formulas previously but the COUNTIF is causing me problems. Or I'm just doing something silly.

 

[Fluff]

Try it like

Range("F4").Formula2 = "CountIf($B$9:$B$" & LastRow & ",""<>n/a"")"

 

[MARK858]

@Fluff missing an equals sign

Range("F4").Formula2 = "=CountIf($B$9:$B$" & LastRow & ",""<>n/a"")"

 

[Fluff]

Good spot.

 

[sparky2205]

Gentlemen,
thank you very much. As ever I am in your debt.

 

[Fluff]

Glad we could help & thanks for the feedback.