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?