Excel error:"This operation requires the merged cells to be identical"

[larryww]

I get this on a paste special of values. Yes, there are 5 merged cells within the copy source, but there are 5 at the right place on the destination sheet too.

I am copying from {cell A4 to end of sheet1}, to {cell A4 of sheet2}.

Queerly enough, I can paste regularly; I can even paste special "all." But even after that, the paste by values gets this error. Deleting every cell on the source sheet first doesn't work either. Both code and menu routes give the same error.

Are you forbidden to paste values when there are merged cells in the source?

 

[sfvb]

To get around this:
Paste the cells regularly, then do a copy and paste special to the same range.

Example:
Copy {cells A4 to end of sheet1}
Paste regular to {cells A4 of sheet2}.
Then,
Copy {cells A4 to end of sheet2}
Paste Special values to {cells A4 of sheet2}.

 

[larryww]

Thanks, but like I said, I tried that.

Anyone run into this problem? It's flaky to reproduce - I can make sheets that have no problem. It seems to happen mostly when the merged cells are noncontiguous.

Now, if there is a true .ASM --breathing Excel internals guru out there: after the failed paste, the first column only of the destination is marked (selected) - even though a rectangle was attempted. I.e. a blue-selected, blank column is what you see on the source sheet, instead of a rectangle filled with numbers. Maybe some Excel developer will see this and be clued to what's breaking down.