When you have selected the text but before you do the copy, go into Format
Cells Alignment and uncheck the box that says "merge cells". Now copy it,
and go to paste it into the other book. Does that work?

--
Allllen


"Maury Markowitz" wrote:

I'm cutting data from multiple sheets and pasting it into one, using Paste
Values. This has been going OK for a while, but then when I cut data from one
of the sheets, I get the error:

This operation requires the merged cells to be identically sized.

I have no idea what any of these terms mean. I don't know what "merged
cells" are in this context, nor can I figure out where such a thing may be. I
don't know what "identically sized" means, because I'm selecting a single
cell, which is typical for a paste operation. In fact, it's not even clear
what "this operation" is referring too, and I have a feeling it's not "paste".

Anyone know what this means and how to fix it? There's no help on it that I
can find.

Maury