When I copy cells from one workbook and and try to paste them into another
workbook using PasteSpecial/Values, I get the following error: "The operation
requires the merged cells to be identically sized." The destination workbook
is exactly the same as the source workbook since it is just a renamed copy of
the source workbook, so I know the cells are exactly the same. I'm using
Excel 2002 SP-1. Any ideas how to solve this?

You can't copy from one area, and paste Values into an area with merged
cells, even if the layout is identical.

Either unmerge the cells in the destination, or do a normal paste, then
copy the destination, and paste as values onto itself.

Mike W wrote:
When I copy cells from one workbook and and try to paste them into another
workbook using PasteSpecial/Values, I get the following error: "The operation
requires the merged cells to be identically sized." The destination workbook
is exactly the same as the source workbook since it is just a renamed copy of
the source workbook, so I know the cells are exactly the same. I'm using
Excel 2002 SP-1. Any ideas how to solve this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Mike,

There's a knowledgebase record on this:

http://support.microsoft.com/default...b;en-us;176838

Ellen

"Debra Dalgleish" wrote:

You can't copy from one area, and paste Values into an area with merged
cells, even if the layout is identical.

Either unmerge the cells in the destination, or do a normal paste, then
copy the destination, and paste as values onto itself.

Mike W wrote:
When I copy cells from one workbook and and try to paste them into another
workbook using PasteSpecial/Values, I get the following error: "The operation
requires the merged cells to be identically sized." The destination workbook
is exactly the same as the source workbook since it is just a renamed copy of
the source workbook, so I know the cells are exactly the same. I'm using
Excel 2002 SP-1. Any ideas how to solve this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html