Scenario: Range is named "Dog" and the named range Dog refers to A1:D4. The active cell is in cell B3, which is within the named range.

Is it possible to get the name of the named range that the active cell is in? ie return the name "Dog"?