+ Reply to Thread
Results 1 to 4 of 4

names don't show in Name Manager but do in vba

  1. #1
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    names don't show in Name Manager but do in vba

    I was looping through all the names in my workbook and noticed there are a couple names that do not show up in the name manager.
    I am copying sheets from one workbook to a main workbook i dont know if that could cause something.

    What are these, why are they there and is it okay to delete them? I really dont understand why there not listed in the name manger.

    here are a list of the names and the line under the name is what they refer to, the bolded ones do not show up in my name manager.
    Lists!_FilterDatabase
    =Lists!$D$30:$D$32
    'PAVEMENT CALCS'!_FilterDatabase
    ='PAVEMENT CALCS'!$I$28:$Y$43
    _xlfn.IFERROR
    =#NAME?
    _xlfn.NUMBERVALUE
    =#NAME?

    Combined_Heading_Abr
    =OFFSET(Lists!$D$2,0,0,MATCH("*",Lists!$D$2:$D$1000000,-1),1)
    GenSum
    ='General Summary'!$B$14:$BC$1000055
    GenSum_FindPage
    =OFFSET('General Summary'!$B$12,0,0,1,MATCH("Part1",'General Summary'!$1:$1,0)-2)
    GenSum_FindSplit
    =OFFSET('General Summary'!$B$12,0,(MATCH("Part1",'General Summary'!$1:$1,0))-2,1,MATCH("ALT",'General Summary'!$1:$1,0)-(MATCH("Part1",'General Summary'!$1:$1,0)))
    headingAbv
    =OFFSET(Lists!$D$2,0,0,MATCH("*",Lists!$B$2:$B$1000000,-1),1)
    HEADINGS
    =OFFSET(Lists!$B$2,0,0,MATCH("*",Lists!$B$2:$B$1000000,-1),1)
    ITEM
    =QryItem[[#All],[ITEM]]
    QryItem!ItemE13_1
    =QryItem!$A$1:$G$8017
    P1_PartColDropDown
    =IF(DGNClip!$G$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P10_PartColDropDown
    =IF(DGNClip!$QF$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P2_PartColDropDown
    =IF(DGNClip!$BD$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P3_PartColDropDown
    =IF(DGNClip!$DA$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P4_PartColDropDown
    =IF(DGNClip!$EX$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P5_PartColDropDown
    =IF(DGNClip!$GU$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P6_PartColDropDown
    =IF(DGNClip!$IR$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P7_PartColDropDown
    =IF(DGNClip!$KO$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P8_PartColDropDown
    =IF(DGNClip!$ML$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    P9_PartColDropDown
    =IF(DGNClip!$OI$8="X",INDEX(Lists!$I$2:$K$21,MATCH(DGNClip!$G$4,Lists!$I$2:$I$21,0),3):Lists!$K$21,INDEX(Lists!$I$3:$J$22,MATCH(DGNClip!$G$4,Lists!$I$3:$I$22,0),2):Lists!$J$22)
    QryItemNamed
    =QryItem[#All]
    Sort_Repeats
    =OFFSET(ProjectInfo!$BM$6,0,0,MATCH("*",ProjectInfo!$BM$6:$BM$10000,-1),1)
    SortedPageNum
    =Store!$L$2:INDEX(OFFSET(Store!$L$2,0,0,Store!$A$2,1),Store!$A$2-COUNTIF(OFFSET(Store!$L$2,0,0,Store!$A$2,1),"#NUM!"))
    Store_PageList
    =Store!$D$2:INDEX(OFFSET(Store!$D$2,0,0,Store!$A$2,1),Store!$A$2-COUNTIF(OFFSET(Store!$D$2,0,0,Store!$A$2,1),"#NUM!"))
    Store_PartList
    =Store!$E$2:INDEX(OFFSET(Store!$E$2,0,0,Store!$B$2,1),Store!$B$2-COUNTIF(OFFSET(Store!$E$2,0,0,Store!$B$2,1),"#NUM!"))
    Store_SimplePartList
    =Store!$F$2:INDEX(OFFSET(Store!$F$2,0,0,Store!$C$2,1),Store!$C$2-COUNTIF(OFFSET(Store!$F$2,0,0,Store!$C$2,1),"#NUM!"))

    thanks

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: names don't show in Name Manager but do in vba

    Try this code to show all defined names in Name Manager
    Please Login or Register  to view this content.
    Look at your defined names and delete other unneeded defined ones
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: names don't show in Name Manager but do in vba

    are these (filterdatebase, xlfn) just created by excel similar to a print area kind of thing?
    i didnt want to delete the xlfn ones because i didnt know if that was something excel needed. i figured the filterdatabase ones get created when you perform a filter action or sort of something like that.

  4. #4
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: names don't show in Name Manager but do in vba

    Well i'm gonna go with the _xlfn.IFERROR and _xlfn.NUMBERVALUE names should not be delete because i tried to delete them in vba and it wont let you.

    if anyone knows how/why they get created i would like to know.

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help required looking up info from names manager
    By bowen73 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-03-2014, 08:31 AM
  2. Copy ranges of cells using names from the Name Manager - Macro Needed
    By Thor55 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2014, 10:19 AM
  3. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  4. [SOLVED] Defining Names in Name Manager
    By frksdf in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-26-2011, 03:06 AM
  5. Replies: 3
    Last Post: 04-03-2008, 03:16 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1