MergeArea Property

Applies To

Range object.

Description

Returns a Range object that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell. Read-only Variant.

See Also

Merge method, MergeCells property.

Example

This example sets the value of the merged range that contains cell A3.

Set ma = Range("A3").MergeArea
If ma.Address = "$A$3" Then
    MsgBox "not merged"
Else
    ma.Cells(1, 1).Value = "42"
End If