I get an object fail 1004 with that, but thanks anyway. This works just needs a little formatting then good to go, cheers guys.
Sub Sum_Last_Row()
![]()
Set Lastrow = Cells(Rows.Count, "C").End(xlUp).Offset(1, 0) Lastrow.FormulaR1C1 = "=SUM(R2C:R[-1]C)" End Sub
Bookmarks