LinkBack URL
About LinkBacks
Assume MyName is a global named range defined as the merged Range("A1:A2") containing a validated list of animals, with "Cat" chosen.
In B2, =MyName returns "Cat"
In C2, =MyName returns #VALUE
What is wrong with Cell C2?
Thx
Assume MyName is a global named range defined as the merged Range("A1:A2") containing a validated list of animals, with "Cat" chosen.
In B2, =MyName returns "Cat"
In C2, =MyName returns #VALUE
What is wrong with Cell C2?
Thx
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I tried to replicate your criteria's, but seemed to work fine. Please could you upload a sample workbook?
Thanks.
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
How many rows are in your list "MyName" ?
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
Let me rephrase that, is row 3 included in your list. I get the error if row 3 is not part of the MyName range
Not able to replicate via 'example' workbook unfortunately.
Named range consists of a single row, and three columns. (OP should have read "A1:B3"). Moreover, MyName references a validated list via Data > Data Validation > Allow > List =AnimalList (which is located on another worksheet)
I can literally =MyName in some places and it renders as expected. =MyName elsewhere renders #VALUE. Baffled and I consider myself an advanced user. Thanks again for the input.
Figured it out. Changing reference of MyName to only first cell in merged range solved problem.
SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks