Expand Minimize

Range.UnMerge Method (Excel)

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:
© 2014 Microsoft