Hi,

You are probably not getting an answer because something is missing in your
question. There is no problem copying a range, some cells of which are
merged and some cells of which are not merged.

The problem arises if there are merged cells in the destination sheet/range.
Also, there may be a version issue, so tell us what version of Excel you are
using.

Cheers,
Shane

"pai_kanwar via OfficeKB.com" <u40955@uwe wrote in message
news:7f29cdddb7a73@uwe...
Dear sir,

when I copying the sheet the message shown ( cannot
change the part of a merge cell)
Is there any way without unmerged the cell.
Because I have 253 out of 1024 merge, cell to copy to another sheet it is
not
possible for me to first unmerge the cells and than merged one by one

I have post my problem in so many sites but i cannot find any specific
solution.

How can I resolve it?

Thanks and help me to resolve this problem

Hardeep kanwar

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1