Summing last row in list

E

Ed

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

Ed

Range("C65536").End(xlUp).Offset(1, 0).FormulaR1C1 = _
"=SUM(R2C:R[-1]C)"

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF Statement in Word 5
formula for arriving net difference 0
Sum a variable length column 1
Find percentage of sums 3
Getting a Grand Total in Grand Total field only 3
Conditional Formatting with VBA 4
Sum Function When Formula Produces #N/A 2
Copy Formula Down until last row 2

Top