Range.SpillParent (Excel)

If a cell is a member of a spill, returns the cell containing the formula responsible. Otherwise, an error is returned.

This property is present in dynamic array enabled Excel. Before calling Range.SpillParent, you may want to first test if a cell is a member of a spill range using Range.HasSpill.

Dim rngSpillParent As Range
Set rngSpillParent = ActiveCell.SpillParent