Forum Discussion
Name Manager question
Hi there, I am new to this Community and hope someone can help me with an excel issue. I am working in a workbook with several tabs where I have used Name Manager to reference different columns etc i...
Hi Mathetes,
Thank you so much for responding and it seems you are right. I see that I have a mix of scope and the named ranges that are not appearing have a local scope opposed to those that appear and that I can use. Do I need to delete and recreate all the local named ranges?
Thank you so much for responding and it seems you are right. I see that I have a mix of scope and the named ranges that are not appearing have a local scope opposed to those that appear and that I can use. Do I need to delete and recreate all the local named ranges?
JKPieterse's excellent and free Name Manager add-in lets you change defined names from local to global (or vice versa).
- Thanks for this tip! I will certainly have a look at this solution.