From a Dave Peterson post to the wrong posting<g

David McRitchie has a macro that may do what you want:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord Dibben Excel MVP

On Wed, 14 Sep 2005 11:06:45 -0700, "tgdavis"
wrote:

My spreadsheet has a formula repeated in each cell of a column. Is there
anyway that I can insert rows without having to manually copy down the
formula each time?