'I am a VB Novice'
I have a worksheet with a bunch of job data, where I have placed a
CommandButton in the header stateing "To enter new invoice information,
please select a job and click OK". My code is simply this:

Private Sub CommandButton1_Click()

ActiveCell.Offset(1, 0).EntireRow.Select
Selection.Insert Shift:=x1Down

End Sub

I don't know what this means, but it works fine. Problem is that I would
prefer that the row inserted have particular formating and not aquire the
formating of the row above. So, I created this formated row at the top of
the worksheet and did a Hide on it. so now I would like copy and paste that
row just below the row the user selects.