Add new cell to existing formula

[Jason39]

Hey all....looking for a little direction as to how I would write a code for this situation:

I have a macro that adds 10 lines into a worksheet above a certain line. Every tenth line I needed added to an existing formula.

For example:
* Cell E26 = E6 + E16.
* When i execute the code it inserts 10 new lines above E26 and the new formula in Cell E36 should be = E6 + E16 + E26
* i want this code to modify every time I run the insert rows macro.

I am just starting to get more involved with VBA now so my knowledge is pretty minimal...so if you could walk me through this I would greatly appreciate it. Thanks in advance!

[Armando Montes]

Look here, formula and code:
http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm
http://www.ozgrid.com/VBA/sum-every-nth.htm