VBA Formula puts @ into cell and formula doesn't work properly

[GeeWhiz7]

Hi guys,

I am using an R1C1 formula to put a formula into a cell. When I simply type the formula into the cell it works.
When I use the vba below the result puts an @ in and then it doesn't work correctly as it only returns one sequence value and should return more.

.Range("BQ2").FormulaR1C1 = "=SEQUENCE(COUNTIF(RC[-27]:R[" & lrA & "]C[-27],""Model*""))"

Vba Result in the final cell:
=@SEQUENCE(COUNTIF(AP2:AP416,"Model*"))

If I hand-remove the @ then it works so

What I want in the final cell
=SEQUENCE(COUNTIF(AP2:AP416,"Model*"))

Any ideas how to keep the @ out of the final cell?

 

[Fluff]

You need to use Formula2R1C1 rather than FormulaR1C1

 

[GeeWhiz7]

You need to use Formula2R1C1 rather than FormulaR1C1

doh. Thanks Fluff

 

[Fluff]

Glad to help & thanks for the feedback.