David McRitchie has a macro that you may want to review:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas
Phendrena wrote:
Hi,
Is there anyway that I can insert a row and have it copy the formula from
certain cells in the row above? Such as from the columns C & L?
Thanks,
--
Dave Peterson