Create a button to insert a new row.

  • Thread starter Thread starter Sharon
  • Start date Start date
S

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!
 
I can think of many possibilities, but I'm sure you are thinking of something
very specific. Please give more information.
 
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
 
Back
Top