Have a look at David McRitchie's site for a macro to insert rows and maintain
formulas.

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


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 11:49:03 -0700, "tgdavis"
wrote:

I frequently need to insert rows to a worksheet which contains a formula
column. Is it possible to insert a row without having to manually copy down
the formula from the previous row?

Thank-you!