Insert Named Range Into a Cell

[Tondos]

Can I insert the actual Name of a Named Range into a cell on my worksheet?
example: I name the range B13551397 'Current Forecast'. Can I have cell
B1398 automatically populate the Actual Name of the Range, 'Current Forecast'?
Thanks. Tondos.

 

[Shane Devenshire]

Hi,

I'm not clear on this question. You can manually type a range name in a
cell. But I don't think you can do what I think you are asking for without a
VBA function.

Shane Devenshire

 

[Tondos]

I was hoping there was a Cell funtion something like '=Now()' which returns
the date and time in the Cell, but would return a certain Named Range
instead.
But I think you're correct, some Code is the only solution. I'm a novice
with VBA, any good code for me?!
Thanks for the response.
Tondos