SidBord
Active Member
- Joined
- Aug 23, 2004
- Messages
- 346
I have a LOT of defined names for individual cells that have a scope of “worksheet”. I have to change the scope for these names to “workbook”.
So far I’ve been deleting each name then defining a new version. There’s got to be a simple way of doing that, but I can’t find it. The defined name wizard has the scope box grayed out so no help there. Anyone know how to make this conversion in an EASY fashion?
Sid
So far I’ve been deleting each name then defining a new version. There’s got to be a simple way of doing that, but I can’t find it. The defined name wizard has the scope box grayed out so no help there. Anyone know how to make this conversion in an EASY fashion?
Sid