Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names starting with underscores?
When I use the menu to look at a list of range names, ones starting with
underscores do not appear. But when I run through all of them in a macro they show up. Just what are they and where do they come from? Don <www.donwiss.com (e-mail link at home page bottom). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names starting with underscores?
Some names are not visible in the namebox. It'll depend on what the name refers
to. Names that point at dynamic ranges won't be visible there, but will be visible in the insert|Name|define dialog. What does the name point to? Don Wiss wrote: When I use the menu to look at a list of range names, ones starting with underscores do not appear. But when I run through all of them in a macro they show up. Just what are they and where do they come from? Don <www.donwiss.com (e-mail link at home page bottom). -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names starting with underscores?
On Fri, 22 Feb 2008, Dave Peterson wrote:
Don Wiss wrote: When I use the menu to look at a list of range names, ones starting with underscores do not appear. But when I run through all of them in a macro they show up. Just what are they and where do they come from? Some names are not visible in the namebox. It'll depend on what the name refers to. Names that point at dynamic ranges won't be visible there, but will be visible in the insert|Name|define dialog. The Define dialog is where they are not appearing. What does the name point to? This is at work, and I have to post from home. But I believe they were graphic objects. Don <www.donwiss.com (e-mail link at home page bottom). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names starting with underscores?
If you mean like the names of buttons/comboboxes/pictures, then you won't see
those names in the insert|Name|define dialog. These object names aren't those kinds of names. And this may not useful for you original question, but get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It'll make working with names (still not object names) much easier. Don Wiss wrote: On Fri, 22 Feb 2008, Dave Peterson wrote: Don Wiss wrote: When I use the menu to look at a list of range names, ones starting with underscores do not appear. But when I run through all of them in a macro they show up. Just what are they and where do they come from? Some names are not visible in the namebox. It'll depend on what the name refers to. Names that point at dynamic ranges won't be visible there, but will be visible in the insert|Name|define dialog. The Define dialog is where they are not appearing. What does the name point to? This is at work, and I have to post from home. But I believe they were graphic objects. Don <www.donwiss.com (e-mail link at home page bottom). -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
names starting with !IDX | Excel Programming | |||
Control ToolBox - CommandBox Accelerator Underscores - Retry | Excel Programming | |||
Name Ranges: Function to convert special characters underscores | Excel Worksheet Functions | |||
How can I replace spaces in text cells (excel) with underscores? | New Users to Excel | |||
using spaces instead of underscores | Excel Programming |