How to add a new line without breaking formulas?

[norolemodelz]

Hi everyone. I need to add a new blank line between the selected rows for the project plan. Almost every cell has formulas, and this new line must be the same. How can I handle without mess?

 

[Yongle]

Here is VBA solution

Test this on a copy of your worksheet - new row created in row below the active cell

With the cursor in G5
- inserts new row in row 6
- formulas and formats copied from row5 to row 6

Put in a standard code module

Sub InsertRowBelowActiveCell()
  Dim rng As Range, cel As Range
  Set cel = ActiveCell

  With cel
    Set rng = .EntireRow.SpecialCells(xlCellTypeFormulas)
    .Offset(1).EntireRow.Insert Shift:=xlDown
    .EntireRow.Copy
    .Offset(1).EntireRow.PasteSpecial xlPasteFormats
    rng.Copy rng.Offset(1)
  End With

  Application.CutCopyMode = False
End Sub

I have no idea what will happen with your merged cells - test and see if it works.
Merged cells may cause problems that cannot be easily resolved - including code refusing to run.