Range.UnMerge Method

  • Article
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