Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd names defined as arrays of constants?!?
I have a spreadsheet with some range names in it (at least that's what I
think they are) whose definitions dont look like [file]'sheet'!range, and whose names have periods, which is normally illegal. For example: wrn.Assumptions. is defined as ={"Assumptions",#N/A,FALSE,"Model"} I can see these names only from code, i.e., by enumerating ThisWorkbook.Names -- they don't appear in Insert/Name/Define, Insert/Name/Paste/List or Goto or anywhere else, and there are no formulas which refer to any of these names. And when I try to delete them in code, they won't go away. What are these, and how do I get rid of them? -- Andy Smith Senior Systems Analyst Standard & Poor''s, NYC |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd names defined as arrays of constants?!?
See reply in Programming.
-- Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "Andy Smith" wrote in message ... I have a spreadsheet with some range names in it (at least that's what I think they are) whose definitions dont look like [file]'sheet'!range, and whose names have periods, which is normally illegal. For example: wrn.Assumptions. is defined as ={"Assumptions",#N/A,FALSE,"Model"} I can see these names only from code, i.e., by enumerating ThisWorkbook.Names -- they don't appear in Insert/Name/Define, Insert/Name/Paste/List or Goto or anywhere else, and there are no formulas which refer to any of these names. And when I try to delete them in code, they won't go away. What are these, and how do I get rid of them? -- Andy Smith Senior Systems Analyst Standard & Poor''s, NYC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrays/Names in spreadsheet. | Excel Discussion (Misc queries) | |||
Arrays & Defined Names | Excel Discussion (Misc queries) | |||
passing arrays to user defined functions | Excel Worksheet Functions | |||
Linking arrays and Worksheet names | Excel Worksheet Functions | |||
copy a set of names(constants) from 1 workbook to another | Excel Discussion (Misc queries) |