How to make a concatenated formula string calculate?

[gravanoc]

I create the following formula in VBA using concat operators:

rvRng.Offset(0, 3).FormulaR1C1 = _
        "=""=IFERROR(SUM('RV #"" &[@[Account '#]] & "" - "" &[@[Unit Name]] & ""'!D:D), $0.00)"""
    rvRng.Offset(0, 3).Copy
    rvRng.Offset(0, 3).PasteSpecial xlPasteValues
    ' wksInventory.Calculate (this line doesn't do the trick, unfortunately)

If I click into the cell represented by rvRng.Offset(0, 3), then press F2 then press Enter, the formula will activate and calculate properly. I'm just trying to accomplish this using VBA. I considered SendKeys, but it is probably not reliable enough for this situation. Any ideas?

 

[Joe4]

The beginning of your formula looks funny to me:

rvRng.Offset(0, 3).FormulaR1C1 ="=""=IFERROR...

Why do you have so many equals signs and double-quotes?
It looks to me like you might be entering the formula as text, which is why you have to go into it and press enter to convert it to a formula.

Typically, this formulas should begin like this:

rvRng.Offset(0, 3).FormulaR1C1 ="=IFERROR...

which means you may also need to remove some double-quotes at other spots in your formula.

Typically, when I am doing something like this, what I do is turn on the Macro Recorder, and record myself entering an example of the formula that I want, then stopping the Macro Recorder.
Then, when you view the VBA code, this will show you the basic structure of the formula you need, and then you can edit it to make it more dynamic.