Range.UnMerge Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Separates a merged area into individual cells.

expression .UnMerge

expression A variable that represents a Range object.

This example separates the merged range that contains cell A3.

With Range("a3") 
 If .MergeCells Then 
 .MergeArea.UnMerge 
 Else 
 MsgBox "not merged" 
 End If 
End With

Concepts

Other resources

Show: