Share via


Range.UnMerge Method

Excel Developer Reference

Separates a merged area into individual cells.

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

See Also