Wierd range name defined as array of constants?!?

[Andy Smith]

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?

 

[Joel]

If yo have 2003 then look under this menu

file - Properties - Custom - Properties

These may be queries or tables that have been added into the workbook. the
only way of deleting them is to delete the data in the Assumption worksheet.
Highlight the entire worksheet using Cntl- A and then press the delete key.

 

[Andy Smith]

There are no custom properties, and there's no worksheet named "Assumptions"
-- I checked even the very hidden sheets.

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

If yo have 2003 then look under this menu

file - Properties - Custom - Properties

These may be queries or tables that have been added into the workbook. the
only way of deleting them is to delete the data in the Assumption worksheet.
Highlight the entire worksheet using Cntl- A and then press the delete key.

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?

 

[Charles Williams]

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]

I've tried deleting them in code. I even do On Error Resume Next and
Err.Clear before deleting each one, and checking Err.Number afterward, and
it's zero every time. They don't go away.

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

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

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?

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.

I'm curious.

 

[Charles Williams]

Try using Name Manager ...

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

I've tried deleting them in code. I even do On Error Resume Next and
Err.Clear before deleting each one, and checking Err.Number afterward, and
it's zero every time. They don't go away.

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

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

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?

 

[Dave Peterson]

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.)

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]

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

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.)

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?

 

[Dave Peterson]

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.)

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

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.)

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?