Insert rows using a Macro

[Hlhebert]

Hi,I am going to try and be as specific as possible. I have a project spreadsheet, columns B - AX. Many of the columns have formulas. I want to be able to add a button that when pressed will automatically add rows under the header. I need the formulas in the rows to be included but all numerically correct as they are inserted in the rows. I figured out how to add the button. I also have been able to add a macro to add a row but can not seem to get the formulas to populate. I am not familiar with MACROs so this is very new to me. The formula I have so far is:Sub insert_row() Selection.EntireRow.Insert Range("F" & Selection.Row).FillDownEnd SubF can be any column on the spreadsheet. I need it to be a range of columns and not just a single one. Any help would be appreciated. Thanks

 

[Tuelor]

May you record a macro inserting the row and formulae then assign that to a button?