nitrammada
Board Regular
- Joined
- Oct 10, 2018
- Messages
- 78
- Office Version
- 365
- Platform
- Windows
Hello everyone,
I've searched through the forums and found some excellent code to delete hidden named cells and ranges but none the will delete named cells or ranges that start with an underscore eg '_xlfn'. I have 3 that I want to delete, namely _xlfn.IFERROR, _xlfn.SINGLE and _xlfn.XLOOKUP. They all refer to #NAME? Can anyone help me with some code to delete them?
Thanks in advance.
Adam
I've searched through the forums and found some excellent code to delete hidden named cells and ranges but none the will delete named cells or ranges that start with an underscore eg '_xlfn'. I have 3 that I want to delete, namely _xlfn.IFERROR, _xlfn.SINGLE and _xlfn.XLOOKUP. They all refer to #NAME? Can anyone help me with some code to delete them?
Thanks in advance.
Adam