Thread
:
formula
View Single Post
#
1
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 24
formula
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.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]