display range's "refer to"

[Gates Is Antichrist]

Is there a simple way to display a range's areas or formulas, as you see under menu item Insert/Name/Define ? I.e., the "refers to" string?

If not, would I need to parse and loop with regions and areas? Would I
- check .HasFormula and then grab .Formula? or .FormulaR1C1?
- take rng.areas.count and build it with semicolons if multiple?
- loop through that count with the "Items?" How do I address them? rng(1), rng(2) ?!
Use .Formula of .Text

Tell me it's already available, please!

 

[Scott Huish]

It woud do the whole sheet but couldn't you just use:

CTRL-`

 

[Gates Is Antichrist]

Thanks to Jake - the answer is simply .Address
and from the names() collection, it's .RefersTo