You can very easily go to,
<Insert <Name <Define
And click on the range name in the big window,
Which then displays it in the small window,
Where you can simply change (edit) the last character.

However, the question now becomes, what range does this *new* name define.
You can click in the "Refers To" box, hit <F2 to enter edit mode, and
revise the range address to match the new name, then click <Add.

How extensive *this* address revision is, is what you must determine if this
whole procedure is worth while.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KG" wrote in message
...
Thank you. This is a very useful tip for when I start writing the formulas
for the links.

I take it that there are no shortcuts when it comes to actually writing
the
Range names...

"Dave Peterson" wrote:

You could start your formula and hit the F3 button. You'll see a "Paste
Name
dialog that may make life a bit easier.



KG wrote:

As I prepare to link workbooks, I have to type descriptive range
names, e.g.:

CDA_GrossSales_Case1

Now, the workbook contains 3 different scenarios, therefore there will
also
be named ranges:

CDA_GrossSales_Case2 and
CDA_GrossSales_Case3

There will be several other sets of named ranges and, in each
instance, the
name will only differ by that one differentiating number on the end.
Both
from the point of view of reducing typos and unnecessary typing, I
have been
looking (in vain!) for a way to copy the names from one range to the
next, so
that I all would have to do would be to change that one digit. Any
suggestions?

--

Dave Peterson