| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.UnMerge method (Excel) |
vbaxl10.chm144159 |
|
|
dfc49876-29b0-0b61-fe18-3953438f7452 |
05/11/2019 |
medium |
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[!includeSupport and feedback]