View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeff jeff is offline
external usenet poster
 
Posts: 44
Default Copyi8ng format after row insertion

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