Take a look he

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

It may take a bit of modification to take its formatting from the row
below, rather than above, but it should get you started.

In article ,
Spyder wrote:

Does anyone know how to write a macro that will allow me to insert a row just
one row below the row with an "insert row" button on my worksheet. Basically
what I am trying to accomplish is to have a series of row categories where
information will be entered. If a user would like to add another line to a
category for an additional item, I want them to be able to click a button and
a blank line to be inserted above all the others in the category with the
same formatting as the other lines in the category. It would be great if
this was a generic macro that could be used for multiple categories on a
worksheet when assigned to each categories' separate button.