merged cells
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
|