sort error

[zabiullakhan]

Hi I get an error while doing a sort

"This operation requires the merged cells to be identically sized"

Range(c8).select
Range(Cells(1, 1), Cells.SpecialCells(xlCellTypeLastCell)).Sort Selection, xlDescending

Please help

 

[JamesW]

Hi there,

It's because somewhere in your data you have a merged cell and it can't work out where the cell belongs.

Could you tell me what the range of data is that you want to sort (i.e. A1:A500) and where your merged cell is.

Ideally you should never use merged cells when trying to use VBA, as you can't directly reference them. Merged cells are the devil!

 

[Michael M]

You can't sort a column that contains merged cells.
Best method is to find the merged cells and unmerge them and replace it with...
Select the cells that were merged and then Format / cells/ alignment
Select the horizontal dropdown box and pick "center across selection"
Then try the sort again.