Solved: display range's "refer to"

[TheAntiGates]

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 or .Text ?

Tell me it's already available, please!

[Jacob Hilderbrand]

You can use Address to get that.

[VBA]
Range("A1").Address
Range("MyRange").Address
[/VBA]

[Jacob Hilderbrand]

Or if you wanted to see the formula and the resulting address:

[VBA]
Option Explicit

Sub NamesTest()

Dim N As Name

For Each N In ThisWorkbook.Names
MsgBox N.RefersTo
MsgBox Range(N.Name).Address
Next N

End Sub
[/VBA]

[TheAntiGates]

MsgBox N.RefersTo
MsgBox Range(N.Name).Address

Outstanding

[Ken Puls]

Hi there,

If you're just looking to show the formula in a cell, I have an article to do that here.

HTH,