ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   merged cells (https://www.excelbanter.com/excel-programming/367617-merged-cells.html)

Dean[_8_]

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

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



Dean[_8_]

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





NickHK

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







Dean[_8_]

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










All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com