Syntax

expression.UnMerge

expression A variable that represents a Range object.

Example

This example separates the merged range that contains cell A3.

Visual Basic for Applications 
With Range("a3") If .MergeCells Then .MergeArea.UnMerge Else MsgBox "not merged" End If End With
Explode the merged area into constituent parts? Separate a merged cell into individual cells? un merge Un Merge Method UnMerge Unmerge a merged cell? UnMerge Method

See also: