LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wierd names defined as arrays of constants?!? Andy Smith[_2_] Excel Discussion (Misc queries) 1 September 18th 09 10:02 PM
Arrays/Names in spreadsheet. Dan Excel Discussion (Misc queries) 1 October 5th 08 10:07 AM
Arrays & Defined Names Bec Excel Discussion (Misc queries) 2 April 9th 07 09:38 AM
passing arrays to user defined functions ramki Excel Worksheet Functions 2 February 15th 06 08:34 AM
copy a set of names(constants) from 1 workbook to another Rahul Excel Discussion (Misc queries) 3 June 20th 05 10:02 AM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"