Summing Fields

S

stck2mlon

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)
 
J

Juan Pablo González

Sorry, forgot the Offset..

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

Juan Pablo González

Ok, now I forgot the R1C1 !!

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

--
Regards

Juan Pablo González

Juan Pablo González said:
Sorry, forgot the Offset..

ActiveCell.Offset(0, 18).Formula = "=SUM(RC14:RC18)"
Click to expand...
 
Top