named excel lists

H

hidden

I'm somewhat of a newbie, so I may not be asking this question with
the correct terminology. I'd like to define a name and attach it to the
range of an "excel (2003) list". If I add a new row or column to the "excel
list",
then the range is suitable extended. How?
 
H

hidden

I'm somewhat of a newbie, so I may not be asking this question with
the correct terminology. I'd like to define a name and attach it to the
range of an "excel (2003) list". If I add a new row or column to the "excel
list",
then the range is suitable extended. How?
Click to expand...

It's actually easier than I thought. Create an "excel list" using some
means,
say Data > List > Create List. Once list is in place, Define a name whose
value is the range "upperleft" cell of the list and "lower right" of the
list.
I did it by clicking on the cells. As the "excel list" grows or shrinks,
the name's binding is suitably modified. Cool. I was a little thrown off
that the cell's range was in absolute row/col form $A$1. But that doesn't
seem to matter.
 
M

Max

hidden said:
.. say Data > List > Create List.
Click to expand...

Ahh, this option must be a "new" feature,
at least with respect to xl 97 anyway
(It's not in xl 97)

Good to know that you solved your own query !
Thanks for feeding back to the newsgroup.
 
Top