See
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/excel.htm
it will repeat the row with the active cell, with formatting and
formulas by inserted below the row with the active cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TEAM" wrote in message
...

When I insert a row, Excel repeats the formatting for the row it is
inserted next to. However, the merged property is not carried over.
Is there a setting or method for inserting a row and carrying over the
merge property? I know that it can be done with macros...any other
methods??


Thanks!!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=475033