software

you can define a name by simply typing the name in the name box -- the area
where you usually see the cell reference, like A1; to the left of the formula
bar. So that should enable you to avoid the Insert/Name/Define. And you can
speed that process up anyway by typing /ind, using the shortcut keys to get
to the same name.
Insert/Name/Create can create several names at once, but will not all point
to the same range -- it works like this: If I have
a b c
1 2 3
4 5 6 and select these 9 cells and use insert/name/create, it will
default to creating the names from the top row, and the named range quot;aquot; will
refer to the 2 cells containing 1 amp; 4, the name quot;bquot; will refer to 2 amp; 5, and
quot;cquot; will refer to 3 amp; 6. So it's a fast way to name ranges, but I don't think
it's what you want.
Bob Umlas
Excel MVP

quot;Hershmabquot; wrote:

gt; I need to define a set of Named cell ranges referring to the same area in a
gt; set of worksheets. I can do this, but only laboriously, using
gt; Insert/Name/Define.
gt;
gt; But there is another subcommand Insert/Name/CREATE which looks as if it
gt; might make the task easier and so more foolproof. But I cannot find any
gt; documentation on this command. When I try it out, it either returns a
gt; meaningless error message, or does nothing. And there is nothing in HELP to
gt; help.
gt;
gt; Can anyone tell me where I can find the documentation for this subcommand?

Thanks. It will not solve my problem, but at least I know that now, and may
be able to use it in suitable circumstances.

Your answer prompts another question. You say quot;type /ind ....quot;. I have never
heard of that sort of shortcut. Did you literally mean quot;/quot;, or are you
referring to the Alt key? If literally, where do I type it?

quot;Bob Umlas, Excel MVPquot; wrote:

gt; you can define a name by simply typing the name in the name box -- the area
gt; where you usually see the cell reference, like A1; to the left of the formula
gt; bar. So that should enable you to avoid the Insert/Name/Define. And you can
gt; speed that process up anyway by typing /ind, using the shortcut keys to get
gt; to the same name.
gt; Insert/Name/Create can create several names at once, but will not all point
gt; to the same range -- it works like this: If I have
gt; a b c
gt; 1 2 3
gt; 4 5 6 and select these 9 cells and use insert/name/create, it will
gt; default to creating the names from the top row, and the named range quot;aquot; will
gt; refer to the 2 cells containing 1 amp; 4, the name quot;bquot; will refer to 2 amp; 5, and
gt; quot;cquot; will refer to 3 amp; 6. So it's a fast way to name ranges, but I don't think
gt; it's what you want.
gt; Bob Umlas
gt; Excel MVP
gt;
gt; quot;Hershmabquot; wrote:
gt;
gt; gt; I need to define a set of Named cell ranges referring to the same area in a
gt; gt; set of worksheets. I can do this, but only laboriously, using
gt; gt; Insert/Name/Define.
gt; gt;
gt; gt; But there is another subcommand Insert/Name/CREATE which looks as if it
gt; gt; might make the task easier and so more foolproof. But I cannot find any
gt; gt; documentation on this command. When I try it out, it either returns a
gt; gt; meaningless error message, or does nothing. And there is nothing in HELP to
gt; gt; help.
gt; gt;
gt; gt; Can anyone tell me where I can find the documentation for this subcommand?