Help with a Script to Add New Line & Copy formulas

[yvettew78]

Hi Everyone

I am trying to work out a script so that when I click on the PLUS Button I have created, it inserts a new row and inserts the formulas that relate to it. Please see a screenshot of the sheet (I want it to add a new row after B18 and copy the formulas that are in Cells B18, D18 & E18).

Thank you

 

[Michael M]

Try

Sub MM1()
Cells(Rows.Count, "B").End(xlUp).Offset(-1, 0).EntireRow.Copy
Rows(Selection.Row - 1).Insert
Application.CutCopyMode = False
End Sub

 

[yvettew78]

Hi Michael

Thank you for your quick response.

Will this code work with Google Sheets?

 

[Michael M]

Don't know....don't use 'em.
Try it !