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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:98554A3A-C205-44CF-BD63-(E-Mail Removed)...
> 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?
>>
>>
>>