Excel Macro to add a new row two rows above a cell with a named range.

[Mrs_Sant0s]

Hi there. Hope someone can help. I have a specified cell which i have given a named range ("Demo_Total"), and I want to create a macro that will add a new row two rows above the named range cell and also copy the formula of an existing row above that.

I created the following, which allows me to find the named range and add a row directly above, but I can't work out how to make it two rows above, and how to copy the formatting from another row.

Application.Goto Reference:="Demo_Total"
Selection.EntireRow.Insert
End Sub

Hope someone can point me into the right direction?

Thanks!

 

[sykes]

Not sure about the formatting, but this should do as you wish, to insert the row.
NB test on a COPY of your work, first!

Sub insert_row_above()
With ActiveSheet
    .Cells(.Range("Demo_Total").Row - 2, 1).EntireRow.Insert
End With
End Sub