I just created a Dynamic Defined Named Range following this references:
http://www.ozgrid.com/Excel/DynamicRanges.htm
http://support.microsoft.com/kb/830287
It works perfectly, except for the fact that the Named Range is not appearing in the "Name Box". The curious thing is that the named range is working fine. For example, if I created a Dynamic Named Range named "Currencies" and I go to the "Name Box" and type "Currencies" it will automatically select the appropriate range. But if I just go to the "Name Box" and try to find the range "Currencies" I won't be able to find it.
Anyone experienced anything similar? Any ideas of what's happening or how can I solve it?
Many thanks in advance!
http://www.ozgrid.com/Excel/DynamicRanges.htm
http://support.microsoft.com/kb/830287
It works perfectly, except for the fact that the Named Range is not appearing in the "Name Box". The curious thing is that the named range is working fine. For example, if I created a Dynamic Named Range named "Currencies" and I go to the "Name Box" and type "Currencies" it will automatically select the appropriate range. But if I just go to the "Name Box" and try to find the range "Currencies" I won't be able to find it.
Anyone experienced anything similar? Any ideas of what's happening or how can I solve it?
Many thanks in advance!