Thread: Summing Fields
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
  
Posts: 226
Default Summing Fields
Ok, now I forgot the R1C1 !!

ActiveCell.Offset(0,18).FormulaR1C1 = "=SUM(RC14:RC18)"

--
Regards

Juan Pablo González

"Juan Pablo González" wrote in message
...
Sorry, forgot the Offset..

ActiveCell.Offset(0, 18).Formula = "=SUM(RC14:RC18)"

--
Regards

Juan Pablo González

"stck2mlon " wrote in message
...
With each line entered into my spreadsheet I want =SUM(N3:R3) to adjust
to the row I am inserting into. Any suggestions?

ActiveCell.Offset(0, 18) = "=SUM(N3:R3)"


---
Message posted from http://www.ExcelForum.com/





Reply With QuoteReply With Quote