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,
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

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

Dean,
Going the single-column-at-a-time route should suit you or see:
http://www.support.microsoft.com/?sc...d=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" wrote in message
...
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

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

"NickHK" wrote in message
...
Dean,
Going the single-column-at-a-time route should suit you or see:
http://www.support.microsoft.com/?sc...d=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" wrote in message
...
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