Defined names are actually Named Formulae, although most people call them
Named Ranges because thats what they are most often used for.

So you can define a name as any valid Excel formula, which includes arrays
of constants or things like Dynamic Range Names.

You should be able to delete them using code, or try using Name Manager
(download from http://www.decisionmodels.com/downloads.htm)


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