Range.MergeArea Property

Syntax

expression.MergeArea

expression A variable that represents a Range object.

Remarks

The MergeArea property only works on a single-cell range.

Example

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

Visual Basic for Applications
`Set ma = Range("a3").MergeArea If ma.Address = "$A$3" Then MsgBox "not merged" Else ma.Cells(1, 1).Value = "42" End If`

merge merge area Merge Area Property MergeArea MergeArea Property Obtain the range for a particular merged cell? Return the merged range containing a specified cell?

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: