Range.MergeArea (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.

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

Dim rngMergeArea As Range
Set rngMergeArea = ActiveCell.MergeArea