Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] harm.charles@gmail.com is offline
external usenet poster
 
Posts: 24
Default 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.