nyconfidential
New Member
- Joined
- Jul 22, 2015
- Messages
- 49
- Office Version
- 365
- 2016
Hi all - I have a worksheet that contains about 20 WORKSHEET scoped named ranges. Normally, when I delete a sheet with worksheet level named ranges, the named ranges are automatically removed. When I delete this particular sheet - the named ranges are still there - but they are turned into WORKBOOK scoped named ranges, all with a value of #REF . Anyone seen behavior like this before?
Here is how the named ranges look BEFORE the sheet is deleted:
https://imgur.com/a/bQUDf6s
Here is how the named ranges look AFTER the sheet is deleted:
https://imgur.com/a/nIbrcKm
Additionally, when I try to delete them grammatically in VBA(just looping through named ranges that have #REF as a value), it does not work(The code works fine normally), are these some sort of ghosts or something?
Thanks in advance.
Here is how the named ranges look BEFORE the sheet is deleted:
https://imgur.com/a/bQUDf6s
Here is how the named ranges look AFTER the sheet is deleted:
https://imgur.com/a/nIbrcKm
Additionally, when I try to delete them grammatically in VBA(just looping through named ranges that have #REF as a value), it does not work(The code works fine normally), are these some sort of ghosts or something?
Thanks in advance.
Last edited: