unmerge with macro

[Alfred]

Hi
Is it possible to write a macro to find all merged cells and then either
delete them or unmerge them.
Thanks for help
Alfred

 

[Dave Peterson]

Record a macro when you select all the cells and remove the merged cells (from
the alignment tab of the format dialog).

 

[JE McGimpsey]

One way:

Public Sub UnmergeAll()
ActiveSheet.Cells.MergeCells = False
End Sub