How to remove @ character in formula in excel

[hoacvxd]

I use C# to create formulas in excel and have encountered a problem: The formula always appears the @ character immediately after the = sign and the result always gives the error #VALUE!.
After creating the formula, I used the Replace function to remove the @ character, but it didn't work.
Please, how to remove the @ character in the formula?

[#2 · Accepted solution]

@hoacvxd 

Try

endRan.Formula2 = strFormula;

[#3]

@Hans Vogelaar 

Thank you, after I switched to cells object and applied Formula2 this solved the problem.