Copyi8ng format after row insertion

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I written code to insert a row. I am wanting to copy the
formatting of the row directly above the row I just
inserted (in the code below, row 34). Here is the code,
can someone please assist? Thanks.

Private Sub FXFE_Exp_Click()
Rows(34 + 1).EntireRow.Insert
End Sub
 
Private Sub FXFE_Exp_Click()
Rows(34 + 1).EntireRow.Insert
Rows(34).Copy
Rows(35).PasteSpecial Paste:=xlFormats
Application.CutCopyMode = False

End Sub
 
Back
Top