Summing Fields
 

With each line entered into my spreadsheet I want =SUM(N3:R3) to adjus
to the row I am inserting into. Any suggestions?

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

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

Summing Fields
 

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/

Summing Fields
 

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/

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/

Summing Fields
 

Man, it seems everyone here is incredibly good. Thanks a ton

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