Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?

Try Paste Special Then
Paste Values

"Al Franz" wrote:

Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?

Maybe I'm confused, but I have only received this message if I am trying to
paste to a merged cell? In other words, when the destination contains a
merged cell, and pasting would result in the merged cells being changed?
Pasting a merged cell to another area does not generate an error. If you
simply paste, it pastes as a merged range. If you paste special, and then
paste values, it only pastes the value - in one cell - as it should?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Al Franz" wrote:

Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?

With VBA it is

Sub CopyMerged()
'A1, B1 & C1 are merged
Range("A1").Copy Range("E1")
End Sub

Seems to work for me.
Mike F

"Al Franz" wrote in message
...
Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?

Get the error that "This operation requires the merged cells to be
identically sized."

"Mike" wrote in message
...
Try Paste Special Then
Paste Values

"Al Franz" wrote:

Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?