Range.Formula= in VBA throws a strange error

Question

This except of VBA code

summ = "СУММ(AQ" + Format(first) + ":AX" + Format(last - 1) + ")"
cell = "AQ" + Format(last) + ":AX" + Format(last)
r.range(cell).Formula = "=" + summ

should insert a formula, e.g. =СУММ(DW6:EI18) into DW19.

(СУММ is a Russian localized name for SUM)

What happens is that correct formula above appears at its proper place but displays a #NAME error. If I select the cell, put the cursor on the formula, and press enter, the formula doesn't change but starts working.

How to make the code above work?

Answer 1

Try this instead

summ = "=СУММ(AQ" + Format(first) + ":AX" + Format(last - 1) + ")"
cell = "AQ" + Format(last) + ":AX" + Format(last)
r.range(cell).Formula = summ

Answer 2

You need to set FormulaLocal instead of Formula because you use the Russian functionnames.

r.range(cell).FormulaLocal = "=" + summ

Answer 3

I think it is the FormulaLocal answer from Marg (1st answer) even though OP hasn't marked it. There is nothing wrong with the formula itself.