Thread: merged cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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