For a possible solution see:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Regards,

Peo Sjoblom

"ksr" wrote:

I would like a formula to to stay in a column. If I insert a new row. The
new row does not have the formula attached to the cell. All I have is one
formula adding all the cells together in the row. I auto filled the column
with the formula, but if we have to insert a row that row does not have the
formula. Is there anything out there that will fix this problem.
Thanks
--
karenr