Excel.Range.MergeArea.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.MergeArea property (Excel)	vbaxl10.chm144160	vbaxl10.chm144160	Excel.Range.MergeArea	68586bba-fa9c-e0d4-0eae-a08613551a2c	05/11/2019	medium

Range.MergeArea property (Excel)

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.

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.

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

[!includeSupport and feedback]