| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Operation requires the merged cells to be identically sized
hi
merged cells. the error message you received sez it all. pre-format the new sheet with the merged cells and you might be able to do it. key word....might.... personal opinion...(extreme i admit) merged cells are about the dumbest thing xl developers ever came up with. the only thing that it does is make the sheet look "pretty?" but it screws everything else up. as you have discovered. get rid of the merged cells and your problems will "mysteriously" go away. funny about that. Regards FSt1 "David" wrote: How do I copy an existing worksheet with formulas into a new workbook with just data using special paste function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Odd error - "This operation requires merged cells..." | New Users to Excel | |||
| how to identically size merged cells for filtering use | Excel Worksheet Functions | |||
| Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Hybrid Mode
