Forum Discussion
jmcclaskey54
Mar 25, 2025Copper Contributor
change scope of named arrays
I have about 40 lists (arrays) with defined names on a separate sheet from my working sheets. I needed to modify a dozen or so of the arrays. I duplicated the original array sheet -- the duplicated arrays now have a scope limited to the duplicated sheet. Having modified their names in Name Manager, I need to reassign the scope of the modified arrays to "Workbook" and the originals to their own sheet only. How do I do this efficiently, as Name Manager does not allow direct modification of the Scope field in its window. I am interested because this process will have to be applied to hundreds of arrays.
1 Reply
Download and install Jan Karel Pieterse's excellent and free add-in Name Manager. It lets you change the scope of selected defined names.