ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
Is there a way to make the name of a named range = the worksheet name, and dynamic so that if the worksheet name changes, the name of the named ranges changes as well?
I know I can use =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) to get the sheet name in a cell and can use that to "Create from Selection" under "Defined Names" on the ribbon. But that only works to name the range the first time; it is not dynamic.
It would be preferable if this could be done without VBA. Thanks
I know I can use =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) to get the sheet name in a cell and can use that to "Create from Selection" under "Defined Names" on the ribbon. But that only works to name the range the first time; it is not dynamic.
It would be preferable if this could be done without VBA. Thanks