LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Wierd range name defined as array 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
Wierd names defined as arrays of constants?!? Andy Smith[_2_] Excel Discussion (Misc queries) 0 September 18th 09 08:01 PM
using user defined constants ravi Excel Programming 5 October 26th 05 04:41 PM
Enumerated constants defined where? JW[_5_] Excel Programming 6 July 23rd 04 10:47 AM
Defined named range to array MattShoreson[_2_] Excel Programming 1 December 4th 03 10:06 AM


All times are GMT +1. The time now is 06:16 AM.

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"