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 a...
HansVogelaar
Mar 26, 2025MVP
Download and install Jan Karel Pieterse's excellent and free add-in Name Manager. It lets you change the scope of selected defined names.