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

--
Regards,
Tom Ogilvy


"Jeff" wrote in message
...
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