Hi How would I add a sum formula to the last row with data in it for column C Thanks for your help.
E Ed Nov 12, 2003 #1 Hi How would I add a sum formula to the last row with data in it for column C Thanks for your help.
T Trevor Shuttleworth Nov 12, 2003 #2 Ed Range("C65536").End(xlUp).Offset(1, 0).FormulaR1C1 = _ "=SUM(R2C:R[-1]C)" Regards Trevor