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
Bookmarks