SUM formula issue

[andrewb90]

I have in column D a sum formula that just counts the total from Column C. Now when I run a macro, A new Column C is added and now Column E is my line with the Sum formulas.
What I am trying to do is have the formula sum up from column C up to the current column.

For example:

F8 has a Sum formula: it should sum up C8:E8. Then a new Column is added and G8 now has the Sum formula and the sum should now run from C8:F8.

 

[JackDanIce]

If C is always your starting column, then you could add the following after you've inserted the column:

Dim j as Long
j = cells(8, Columns.Count).End(xltoLeft).Column
cells(8,j).Formula = "=SUM(C8:" & cells(8,j-1) & ")"

 

[andrewb90]

I get Error 400.

I am just running this as a separate Macro.

 

[JackDanIce]

Try:

j = Cells(8, Columns.Count).End(xlToLeft).Column
Cells(8, j).Formula = "=SUM(C8:" & Cells(8, j - 1).Address & ")"

Or post your full code so people reading can better understand the stage you are reaching before encountering your problem