unmerge with macro
 

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

unmerge with macro
 

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

Alfred wrote:

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

unmerge with macro
 

One way:

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

In article ,
"Alfred" wrote:

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