VB for Excel - auto detect merged cells?

I have an excel spreadsheet with many rows and columns. I'm trying to sort all the columns but I get there error that merged cells exist and must be the same size.

Is there a way to either automatically un-merge cells, or at least scan the workbook for the location of the merged cells?

Thanks! Dan

You may have to loop through the cells in that column but this will determine a boolean of if its a merged cell.

VB Code:

[i]range or cell object.[/i]CellFormat.MergeCells