LinkBack URL
About LinkBacks
Hi Guys,
is there a function to return the name of a named range (if it exists) of the Target.Address?
Regards
Determine what Named Range the Target Address is and return Named Range Name
Hi Guys,
is there a function to return the name of a named range (if it exists) of the Target.Address?
Regards
Hello jordan2322,
No there is not. But one could be written using VBA.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Something like this?
How would i modify this such that the target.address only needs to be within the named range - not match the named range address exactly.
As the named ranges are more than a single cell this (as written in the code below) would be impossible as the user can only double click a single cell not a range.
(note: I want this to be called using the double click event)
Please Login or Register to view this content.
Try this
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Solved using the above. Thank you Mikerickson for your reply!Please Login or Register to view this content.
What happens if the cell you click on is in more than one named range? Do you want all named ranges that contain the double clicked cell to appear?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks