Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Misbehaving » Excel 2007 misbehaving with named ranges

Excel 2007 misbehaving with named ranges

Previous | Next
Latest post Wed, Dec 17 2008 4:44 PM by Nick Hodge. 1 replies.

  • Wed, Dec 17 2008 4:25 PM

    • billwzw
    • Not Ranked
    • Joined on Wed, Dec 17 2008
    • Posts 1
    • Points 21

    Excel 2007 misbehaving with named ranges

    Reply |Contact

    I have a funny problem - I've got a workbook with several named ranges in it.  When I use Formulas > Name Manager (without Filters) it doesn't show one of the named ranges !  I can use this range with no trouble, and the name is the first reported by VBA code (code from http://spreadsheetpage.com/index.php/tip/working_with_names_in_vba/) to list all named ranges.  So it clearly exists, why doesn't the Name Manager show it ?

    Any ideas ?

    Thanks,

    Billwzw

     

     

     

     
    • Post Points: 21

  • Wed, Dec 17 2008 4:44 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 543
    • Points 9,287
    • MVP

    Re: Excel 2007 misbehaving with named ranges

    Reply |Contact |Mark as Answer

    Billwzw

    If a name is set up through VBA it can be set to Visible=False and it will not show in the UI, e.g this VBA code

    Sub CreateHiddenName
    ThisWorkbook.Names.Add "Test1",,"False",,,,,"=$A$2"
    End Sub

    Sets a range name of Test1 in cell A2 and marks it as hidden, It will not now show in name manager

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under:
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.