Copy Merged Cells to Single Cells ??

A

Al Franz

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?
 
G

Guest

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?
 
M

Mike Fogleman

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
 
A

Al Franz

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strip out certain rows that have merged cells 2
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
Problem with pasting special merged cells to merged cells 3
Windows 7 Autofit row heights of merged cells in protected worksheet 0
if for merged cells 4
Clearing Merged Cells 4
Referencing Merged Cells in VBA 8
Copy data from Single cell to Merged cell 4

Top