David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows.

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

Floyd Elkins wrote:

I need to be able to enter a given number into a column in Excel and have
that number of rows added in the next row (copied from another row).

--

Dave Peterson