Excel formula not calculating

[baba92]

Hi,
I tried to simplify my issue: I wrote in my cell C2 the following formula: '=SUM(1;2)

When I copy paste this formula in cell C4 I can read =SUM(1;2) in the cell but it does not calculate it. I need to click in the formula and just press enter for it to calculate.
I assume the quote is messing things up but when I control F for the quote, excel tells me there is no quote so I can't remove it.
I also did control F and replaced "=" by "=" which worked but it does not work on vba, I don't know why.

Basically I want my vba code to do this for many formulas. Copy pasting the formulas and then calculating it automatically.
I tried range("C4").formula=range("C2").formula but I received an error message ("Application-defined or obkect-defined error")

Do you have an idea?

 

[6StringJazzer]

Sub Macro6()
Range("C4").Formula = Range("C2").Formula
End Sub

I receive this message "Application-defined or object-defined error"

The only way you will get that error with this code is if the sheet is protected and C4 is locked.