Re: Name a list in Excel 2003?

I think that this is just excel's way of helping.

If you have any range selected, then the top left cell is used as a suggestion
for a new name (not existing, though) and the selected range's address is used
as a suggestion for the refers to string.

I think you just saw normal (helpful, <bg>) excel behavior for naming
ranges--not for naming the listobject itself.



Roger Govier wrote:

hmmmm.....

I agree Dave.
However, start again on a blank ***.
Immediately after creating the list, with the cursor within the list, go
to Insert>Name>Define
I then see the name of the first column, with a range that refers to the
List range. Clicking the icon at the end of the Refers to pane, selects
the range.

Do anything else, then return to Insert Name and the name disappears.

First time through, you can rename that range to another Name.
Very strange.

Tiredness now getting the better of me, but I will take this up again
later if you have any further thoughts/findings.
--
Regards

Roger Govier

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:468B00A9.CE694A78@xxxxxxxxxxxxxxxxxxx
I couldn't duplicate this in xl2003.

I put a bunch of test data (pretty much random stuff) in A1:F22 and
then used
data|list and said my list had headers.

Then I did this in VBE's immediate window:
debug.Print active***.listobjects(1).name

I got this back:
List1

There were no characters in my range that contained the word List1.

I added a couple more lists--some with headers and some without and
did more
debug.prints.

The list names looked like:
List2
and
List3

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

And the only name that showed up (and it was hidden) was:
Sheet1!_FilterDatabase

And interestingly, that moved depending on what the activecell
was--and if it
was in a List.


Roger Govier wrote:

Hi Alun

If the list has headers, then under Insert>Name>Define the list will
be
the name of the first header in the list.
Select the name and give a new name for the range>OK. Delete the
original name.

If there are no headers, then Column1, Column2 etc will have been
inserted.
Insert Name>define>select column1 and give new name>OK. Delete Column
1
as Name.

--
Regards

Roger Govier

"Alun Jones" <alun@xxxxxxxxxxxxx> wrote in message
news:uToyVnbvHHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
In VBScript or C#, I can rename an excel ListObject by simply
writing
a line such as:

ListObject lo = (ListObject)ws.ListObjects["List1"];
lo.Name = "Certificate List";

Now, how do I rename a list using the interactive interface,
without
code?

Thanks,

Alun.
~~~~


--

Dave Peterson

--

Dave Peterson
.

Quantcast