Range("D" & rlRow + 1 & ":O" & rlRow + 1).FormulaR1C1 _
= "=SUM(R[-" & rlRow & "]C:R[-1]C)"

But isn't that pretty much the same as:

Range("D" & rlRow + 1 & ":O" & rlRow + 1).FormulaR1C1 _
= "=SUM(R1C:R[-1]C)"

wrote:

I'm trying to to use this formula, but receive error.

Range("D" & Rlrow + 1 & ":O" & Rlrow + 1).FormulaR1C1 = "=SUM(""R[-" &
Rlrow & "]C:R[-1]C)" & ")"

this is the actual code recorded

"=SUM(R[-40]C:R[-1]C)"

Any help would be appreciated.

--

Dave Peterson