"merged cells must be identical size."

[Guest]

HELP! I have a multiple sheet workbook each with an identical table that
needs to be sorted on a specific column at the end of the month. When I
attempt the sort, however, I get "Merged cells need to be identical size."
The merged cells in question arent even part of the sort range. They are
nothing more than window dressing in the first two rows of the chart -- NOT
the actual data. I attempted to define an area and name it "Database. That
works for one sheet but I CANNOT get it to work for and of the other sheets.
What do I do?

Jaycee.

 

[Gord Dibben]

Insert a blank row below the merged cells then sort below that.

Gord Dibben Excel MVP