Consider formatting the entire column instead of groups of cells.

By default, Range.Insert inherits the formatting of the row above.

You can specify by using the CopyOrigin parameter (XL2002)
Rows(2).Insert xlShiftDown, xlFormatFromRightOrBelow

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Mitch" wrote in message
...
Hello,
I have a problem with my workbook, the wrap text format is not functioning
for the fist 7 rows. My workbook is designed like a template and has 3
macros
that inserts rows, delete rows, and copies previous sheets. Every sheet is
protected. I wonder why the wrap text format is not working for the first
7
rows though it works to the rest of the rows. I badly need help from
anyone,
need to finish this asap. Thanks!