Try Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:
NameManager.Zip from http://www.oaltd.co.uk/mvp

(I'm not sure what you mean by searching the code. I didn't mean that you
created the names in your code. I really meant that excel creates them--whether
you like it or not.)

Andy Smith wrote:

The only add-ins I have enabled are Analysis Toolpak, Analysis Toolpak VBA
and Solver, and I've never used them. However this spreadsheet comes from
elsewhere, and they might use such tools there. FYI I've searched the code
for all these wierd names, and they're nowhere.

--
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC

"Dave Peterson" wrote:

Excel creates names that it uses (without your permission and usually without
your knowledge).

Do you use any of those tools|Data analysis features?

(I don't recognize which wrn.Assumptions belongs to (or if it really does), but
that's where I'd start.)

Andy Smith wrote:

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

--

Dave Peterson


--

Dave Peterson