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!
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!