"all the merged cells need to be the same size" during a Custom Sort

pjflora 

Maybe this information will help you ... if not please just ignore it.

You may receive an error message when you sort a range that contains merged cells in Excel

Symptoms

When you sort a range in a Microsoft Excel worksheet, Excel does not sort the range. Additionally, you may receive the following error message:

This operation requires the merged cells to be identically sized.

Cause

This issue might occur if you sort a range of cells, and if the following conditions are true:

• You previously merged some of the cells, but not all of the cells in the sort range.
• You previously merged all of the cells in the sort range and the cells are not all the same size.

Workaround

To work around this issue, split all the merged cells in the range, or merge all the cells in the range so that the merged cells are the same size. Each merged cell in the range must occupy the same number of rows and columns as the other merged cells in the range.

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)