What are the variable values and what is the manual entered formula? I usually quote the test formula as a comment before .Formula or .FormulaR1C1 so I can see if I get the string right.

e.g.
Debug.Print Application.ReferenceStyle, [A1].Address, [R1C1].Address, [A1].Address(ReferenceStyle:=xlR1C1)