This documentation is archived and is not being maintained.

Range.UnMerge Method

Office 2007
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



Show: