Forum Discussion

jmcclaskey54's avatar
jmcclaskey54
Copper Contributor
Mar 25, 2025

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