Yes, I did a little research and nobody seems to know why EXCEL has trouble
but everyone seems to agree that it does! I found that I could copy (edit
paste special values) cell C1 thru C4 (no merges), then C5 thru C6 (this had
a merge in cells C5 and C6) successfully, but not the entire C1 to C7 block.
Very strange. I think the error message is misleading.

I basically am just highlighting the source sheets, temporarily removing all
the merges (without resaving), then copying that into the destination sheet.
Luckily, the destination sheets (from which I've permanently removed all
merges) are behind the scenes so they don't have to look pretty.

Thanks!
Dean

"NickHK" wrote in message
...
Dean,
Even if the cells are merged the same, Excel seems not able to
PasteSpecial
between if the range is more than a single column.
So either pastespecial a column at a time or don't use merged cells.
Maybe some else knows why this should be so ?

NickHK

"Dean" wrote in message
...
I am trying to copy and edit paste special from one worksheet in one file
to
a similar worksheet in another file.I am getting the following error
message:

The operation requires merged cells to be identically sized.

I cannot find any merged cells in different places between the two sheets.
I also tried to paint the format of one sheet onto the second sheet first.
But it did not help.

What does this message really mean?

Thanks!
Dean