Update Excel sheet with formula

Finally, it doesn’t work.
VBA code fails to initiate interpretation of formulas. VBA considers text to be a constant.

Do you have a solution ?