VB for Excel - auto detect merged cells?

[dbmagnus]

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

[RobDog888]

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

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