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,