Skip to main content

Range.MergeArea property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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.



expression A variable that represents a Range object.


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


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"
    ma.Cells(1, 1).Value = "42"
End If

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>