Hi all,
Short question.
Is there a way to display the name of a named range in a cell of that named range?
Hi all,
Short question.
Is there a way to display the name of a named range in a cell of that named range?
there is
Function nmrng(n As Integer) As String nmrng = Names(n).Name End Function
Thanks for the quick response!
Hello there..
I have a slighty different question but related to similar topic.
I want to display the name of the namerange to which a cell belong to.
For example, cells A1/A2/A3 are called namedrange "my_table". A1/A2/A3 are populated with lion/tiger/hippo.
now in cell F1, if I populate lion, I would like to dispaly its namedrange's name ie my_table in cell F2.
Is this doable?
Based on solution in the spreadsheet in this thread, it looks like it is, but not sure how...
Thanks
Shahab
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks