merged cells

[Dean]

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

 

[NickHK]

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

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

 

[Dean]

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]

Dean,
Going the single-column-at-a-time route should suit you or see:
http://www.support.microsoft.com/?scid=kb;en-us;176838&spid=1759&sid=567.
Whilst this article states "This problem..." there is no acknowledgement of
it being a bug and as this has been the situation since Excel '97, I guess
it is "by design".

NickHK

 

[Dean]

Yes, I find it arrogant of them to not admit it's a bug. The single column
approach does not always work. My example below (all in column C) is proof
of that. Fortunately, I can live with this one.

Thanks, Nick!
D