Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    Cincinnati
    Posts
    36
    Thanks
    0
    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:
    CC!Z_F4B0F3D5_A9F8_4BEC_8049_DADA37A3CADF_.wvu.Row s
    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?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    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)

    Etc

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •