Display name of a named range in cell

[Jesse]

Hello,


I want to display the name of an assigned range in a cell.


Example: Cell

$B$5 is named [code]Population

Example: Range [code]$C$9:$E$20 is named [code]Stats


I want to display the assigned name within a cell (say A1), so that the cell output reads, e.g. [code]Population. If I were to change the name of the assigned range (e.g. from Population

to Pop[/code]) cell A1 would then change as well.


I've played with =INDIRECT()[/code] and =CELL()[/code] and =ADDRESS()[/code] and investigated other functions, but without success.


Is this possible without using VBA? Ideas? Thanks in advance.

 

[SirJB7]

Hi, Jesse!

Never tried until now to do such a thing, but I couldn't. So as far as I can see you can't do it without VBA.

Regards!

 

[Luke M]

It wouldn't be a live update, but you can print all or some of the named ranges From the Formula - Defined Names - Use in formula - Paste Names.

 

[Jesse]

Thanks for the quick reply. I didn't think it was possible, but I thought I'd check.


I'm creating an assessment tool, and there are lots of named ranges, and so I'm trying to minimize the maintenance burden for future developers by using

INDIRECT(CellAddress_holding_RangeName)

.


Thanks again

 

[SirJB7]

Hi, Jesse!

Glad to help even if you couldn't solve it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!