problem with Paste-Special-Values from a List (range of cells)
 

I have Rows 94 to 175 in Columns B:D, E:F, and G ... each cell has a (pick)
List data validation. So, that's about 240 cells, each with a different
pick-list value. I highlight that range (B94:G175) and do a Ctrl-C. Then, I
try to Paste-Special-Values to a different worksheet that has the SAME EXACT
CELL FORMATs. But, I get an error that says "This operation requires the
merged cells to be identically sized."
Why am I getting this error? Or, rather, how can I prevent this error? The
cells ARE identically sized. And, if I do ONE cell at a time, it works fine.
Only when I try to copy/paste two or more cells at the same time do I get
the error.
Any suggestions?

problem with Paste-Special-Values from a List (range of cells)
 

This is a long standing bug (in my opinion) with merged cells. You can do a
PS-Formulas as a workaround I think. You should get the same result as a
PS-Values if you do not have formulas in the source range, which presumably
you don't since these are input cells.

--
Jim
"crimsonkng" wrote in message
...
|I have Rows 94 to 175 in Columns B:D, E:F, and G ... each cell has a (pick)
| List data validation. So, that's about 240 cells, each with a different
| pick-list value. I highlight that range (B94:G175) and do a Ctrl-C.
Then, I
| try to Paste-Special-Values to a different worksheet that has the SAME
EXACT
| CELL FORMATs. But, I get an error that says "This operation requires the
| merged cells to be identically sized."
| Why am I getting this error? Or, rather, how can I prevent this error?
The
| cells ARE identically sized. And, if I do ONE cell at a time, it works
fine.
| Only when I try to copy/paste two or more cells at the same time do I get
| the error.
| Any suggestions?