Hi,
It looks, my last response (followup to my earlier reply), for some reason,
didn't go through.
I forgot to mention that the newly inserted row will have the contents of
the original row along with the merged cell formats. So after inserting the
copied row, delete the contents in the new row.

Regards,
B. R. Ramachandran

"TEAM" wrote:


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