You may want to look at Debra Dalgleish's technique for defining a name that can
grow/shrink when entries get added/removed.
http://www.contextures.com/xlNames01.html#Dynamic
And if you're working with names, do yourself a giant favor and 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
You may want to suggest it to users who think that they'll use names a lot (or
at all!).
Ann Shaw wrote:
Guys Guys Guys please - you both helped me a lot over here
in little olde Dublin, Ireland.
Much appreciated. Hope you got my email Bob - any help on
Macros would be great and thanks a million both Bob and
Jim!!!!
Kind regards
Ann
-----Original Message-----
Hi Jim,
Funny how language is so multi-facetted isn't it :-).
Makes being a
highly-paid lawyer easy :-(
Ann, we all wait with bated breath <g
Bob
"Jim Rech" wrote in message
. ..
When I read your response, Bob, I thought 'that's a
great tip but not what
the OP was asking'.<g So I thought I'd answer her
actual question which
I
took to be "how do I use the Create Names dialog?",
not "why should I use
names?".
If Ann comes back maybe she can tell us who was more
perceptive this
morning...<g
--
Jim Rech
Excel MVP
"Bob Phillips"
wrote in message
...
| Jim,
|
| That's a great tip, but (and this is not meant as
criticism, just extra
help
| for Ann) from the tone of the OP I think Ann would
benefit from some
ideas
| on how to deploy such names. Some occur to me, but as
I presume you
actually
| use this technique I will leave it to you to
|
| Regards
|
| Bob
|
|
| "Jim Rech" wrote in message
| ...
| Insert Names is a fast and convenient way to assign
defined names to
cells
| adjacent to labels, using those labels. An example
makes this easier
to
| follow:
|
| -Enter 3 names in cells A1:A3 (say Jones, Brown,
Smith).
| -Select the 6 cell range A1:B3.
| -Open the Insert Names dialog (Ctrl-Shift-F3 is a
shortcut).
| -Select the Left Column option (it may be selected
automatically).
| -Click OK.
|
| Cells B1:B3 will now have the names Jones, Brown
and Smith.
|
| Has you selected a range with more columns, like
A1:D3, then the names
| would
| have been assigned to the range B1:D1, B2:D2 and
B3:D3.
|
|
| --
| Jim Rech
| Excel MVP
| "Ann Shaw" wrote
in message
| ...
| | Hi
| |
| | I was recently asked in a training class why a
person
| | would use Insert Name Create and I did not know
about
| | this. I usually show my students how to define
names from
| | selected cells. Could you please give me an
example of
| | when I might use Create and what does the dialog
box mean
| | that pops up Top Row, Left Column etc..
| |
| | Many thanks
| |
| | Ann
|
|
|
|
.
--
Dave Peterson