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

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" wrote:

Can I insert the actual Name of a Named Range into a cell on my worksheet?
example: I name the range B1355:P1397 'Current Forecast'. Can I have cell
B1398 automatically populate the Actual Name of the Range, 'Current Forecast'?
Thanks. 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

"Shane Devenshire" wrote:

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" wrote:

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