Help with sum

[lecet444]

I have a vba code that inserts rows and values

at the last row, I want it to do an auto sum for example C13:c(last row).
is there a formula for that.

 

[Smitty]

This might get you started:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> foo()<br>    <SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <br>        i = Cells(Rows.Count, "C").End(xlUp).Row<br>        <br>        Cells(i + 1, "C").Value = Application.WorksheetFunction.Sum(Range("C1:C" & i))<br>            <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[lecet444]

i could do it with code. but there are many different formulas at the bottom. Is there a way i could do it with formula

 

[Smitty]

Sure, just record a macro entering a SUM in C, then replace my line of code with it, exchanging the last row reference with i.

 

[lecet444]

ohh thats actually very clever thanks a lot