is there a way to get the definition of a defined name into an excel cell?

[TomCon]

I want to get the definition of a defined Name into an excel cell.

So, if i have a name, MyName, and it is defined as Sheet1!A1:A10, i want to get the text string "Sheet1!A1:A10" into an Excel cell.

=MyName does not do it.
Also =T(MyName) does not do it.

Is there a way?

Thanks!

 

[Peter_SSs]

Yes, this does work to get a single name but the paste list below gets them all which is what i need. Thanks!

Cheers, glad you got what you wanted, even though it looks a little different to what you actually asked.
Thanks for the follow-up.