Results 1 to 2 of 2
2002-09-28, 16:00 #1
- Join Date
- Mar 2002
- Thanked 0 Times in 0 Posts
Unexpected Defined Names (w2kO2ksr1)
I made a list of the defined names in my workbook, and discovered the following kind of name on several sheets:
Some related to rows, some to columns, and seem to relate to print area definitions.
These names do not show up in the normal dialog box.
I am developing a utility that lets me print parts of my workbook in a kind of batch print, and I reset the print areas using VBA. Is that causing these funny names to be created (but hidden)?
How do I delete a hidden name like this, and do I want to?
2002-09-28, 17:38 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Unexpected Defined Names (w2kO2ksr1)
Some addins will create hidden names, so you might NOT want to delete them.
You can work with hidden ones in VB or even in the immediate window, they are in the NAMES collection
Work with the collection
activeworkbook.Names.count (to count the number of names)
Work with individual names:
activeworkbook.Names(1).Name (the rangename of the 1st one)
activeworkbook.Names(1).refersto (what the 1st one refers to)
activeworkbook.Names(1).visible (whether the 1st one is visible)
activeworkbook.Names(1).Delete (will delete the 1st one)