Hello everyone,
I have a Dynamic Named Range (Entries) that shows in my Name Manager...but is not being recognized in formulas.
The range is defined with a standard DNR formula, and selecting the code in Name Manager highlights the Dynamic Range.
But, when I use the NAME in a simple formula, I get an error. (#NAME?)
Please Login or Register to view this content.
What am I doing wrong?Please Login or Register to view this content.
Have you chosen "Workbook" in the "new Name", "Scope" when you were creating your range?
Not working example below
not working.xlsx
Last edited by RobertMika; 12-30-2013 at 03:15 AM.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
That's exactly what it was, Robert.
The worksheet was copied from another workbook, and the scope was set to the original sheet, itself.
I simply created a new DNR with the scope being my current workbook, and everything works as expected.
Thanks, for exposing me as the dufus that I surely feel like, at the moment.
You are welcome.
Please mark the thread as solved and if you happy with the solution add reputation.
I tried to mark the thread as SOLVED. It won't let me.
When I click the Go Advanced button, nothing happens.
I need to do this on the ORIGINAL post, right? (Been away from the forum for a while).
Select Thread Tools-> Mark thread as Solved.(top of the page right hand side)
Yep...I found that.
Now how do I delete this post, and Post #5??
When I click EDIT POST, I just get an empty field, and no Edit Options.
I am also having a problem with a formula/formulas not recognizing a named range in the formula. My colleague does not have that problem... when he sends me a file I can see it is working properly, but once I press the "Enable Editing" button the formulas all revert to #NAME? errors. Also, if I create a named range, and use it in a formula it works. But when I save, close, and re-open, the same thing happens... all formula referencing that named range change to #NAME? error.
staynerblewis, welcome to the forum.
Administrative Note:
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. Additionally old threads are seldom monitored by the original participants. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks