This is my issue: I was finally able to input a formula into sheets by the range.formula property. The formula is properly displayed (it's a very easy "=SUM(C1;C10)") but returns an #ERROR. When I parse it through the Error's information menu, it says that it's SUM to cause the problem. identical formula works fine when input manually, but the bauty is that if I copy from the sheet's correct formula and paste it into tne range.formula property is stops working once pasted! :o(

the real cell content is as follows (soz, it's in italian)

=somma(C1:C9)

I couldn't find any trailing hidden characters.
Any idea?
Thank you for your time!