Writing formula on Sheet by VBA code, needs Enter Key pressed

Hi everyone,
i wrote a code that copies a formula to specific cells by pressing a button, but i continue to get #NAME? error tag in cells.
But if i enter them and press the Enter Key, the function works.
My request is to get all this done automatically, avoiding having to press each time the Enter Key.

Ops sorry, i thought i posted it.

Here it is :

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Okay thanks! This works fine, but the problem is with this function :

Please Login or Register  to view this content.

Any solution for this?

Ok, problem solved.
I was putting all the functions in italian like IF -> SE ; LEN ->lunghezza
So for everybody! Put the function name in english!

Thank you Fluff13!

You're welcome & thanks for the feedback.

I think that if you use the FormulaLocal, then you can use the Italian names & separators, rather than having to convert to English/US equivalents.