con't paste merged cells

[Guest]

When I try to paste values of a merged cell into another workbook with
exactly the same cell size I get a error message that says "The operation
requires cells to be identically sized" I have re-checked the row height and
the columm width to be sure they are the same size as the original copied
cells

 

[JE McGimpsey]

"Identically sized" refers to the number of rows and columns, not the
height and width. If you have a merged cell or cell(s) in your copy
range, you have to have identically placed merged cell(s) in your
destination range.

In my opinion, this is only one of the reasons that merged cells are the
spawn of the devil and should never be used...

 

[Guest]

It is not the cell size which is being refered to. If you have merged cells
C1 and C2 the paste wont work very well in most cases.
While merging can be useful for displays, they often cause other problems
A work around is to select everything, unmerge paste and merge ahagin if
you need to.

 

[Guest]

It is not the heighth or width that is the issue
Excell lets you merge cells but then doesn't let you do much with the merger.

I woul dtry to see if you can format without merging. and then copy.

 

[Sonsequence]

This method seems to work

For me going to paste special and pasting values and number formats rather than values only seems to work.

Obviously that leaves you without all your formatting so you'll have to first paste it normally, hit delete to empty the cell contents and then Paste Special over that with values and number formats selected.

Probably a good idea to record this as a macro seeing as if you're going to do it once you'll probably do it often.

Hope that works!

(I'm using Excel 2002)