David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Maybe you can modify it to always point at row 6???

Hippy wrote:

Is there a VB command that can copy the formats, formulas and Data Validation
from one cell into another cell.

I have a spreadsheet that I have created all the cell formats (bold, font,
Data Validation) in line 6.

If the user enters into a new line I would like to copy the structure of
line 6 to the new line they are entering on (same column).

Thanks
Hippy

--

Dave Peterson