Create a button to insert a new row.

[Sharon]

I know Excel can do it; I just don't know how. In addition, once the new row
is inserted, I need the formulas to carry into it.

Any help is greatly appreciated!

 

[ryguy7272]

I can think of many possibilities, but I'm sure you are thinking of something
very specific. Please give more information.

 

[Bob Umlas]

Assuming you want the inserted row at the cursor location:
Sub InsertIt()
On Error Resume Next
Rows(Activecell.Row).Insert
Rows(Activecell.Row-1).Resize(2).FillDown
Rows(Activecell.Row).specialcells(xlcelltypeconstants).clearcontents
End Sub