add new rows

[NewAccessUser]

i have row that i need to have copied and inserted directly beneath the
original row preserving all of the rows formulas and cell formatting.
currently, the row i am referring to is a combination of four rows. for
example, A2, A3, A4, and A5 are merged, as are B2, B3, B4, B5. however, this
pattern is not continued across all of the columns of the row. C1, D1, E1 are
merged and therefore one cell. C3, C4, and C5 are not merged (neither are
cells D3, D4, and D5). E3 and E4 are merged together.

A pattern similar to this continues until column I, where the spreadsheet
ends.

I need some sort of a button that the user can press that will automatically
insert the exact row directly beneath the row referred to above. If not a
button, then a box in which a user can input the amount of rows they wish to
have.

I've been working on this for days now and have gotten basically nowhere.
Any help would be greatly appreciated.

Thanks,

 

[David McRitchie]

see
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
it is only set up to insert below one row it is not set up to work
with merged cells, you have to insert 4 rows before the row
after the 4 rows being copied. Then paste the original four rows
to the new four rows, in the new four rows select cells without
formulas and clear them with special cells .