Try with

ActiveCell.FormulaR1C1 = "=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/