Are there any shortcuts to typing range names?

[KG]

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]

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

[KG]

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
>

[Norman Jones]

Hi KG,

Since your names only differ by the last digit, having defined your first
name, you can use this as a template for the successive names: when defining
the second name, click on the (now) existing first name and edit the last
digit and redefine the corresponding range.

This should mean that for each successive name, you only need to type/edit a
single character


---
Regards,
Norman



"KG" <KG@discussions.microsoft.com> wrote in message
news:8CB98020-A92F-4A01-950B-FB59056C91DA@microsoft.com...
> 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]

Kind of like completing variable names in the VBE by hitting ctrl-spacebar?

Not that I know.

KG wrote:
>
> 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
> >

--

Dave Peterson

[Ragdyer]

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" <KG@discussions.microsoft.com> wrote in message
news:9A1D1C3E-6DD3-4CD4-957D-10CAD752C966@microsoft.com...
> 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
> >

[Dave Peterson]

I think the OP was talking about writing the range names in a formula in a
cell--not redefining them--but we may find out soon.

Ragdyer wrote:
>
> 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" <KG@discussions.microsoft.com> wrote in message
> news:9A1D1C3E-6DD3-4CD4-957D-10CAD752C966@microsoft.com...
> > 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
> > >

--

Dave Peterson

[KG]

Thank you all, guys. Dave is right: I was looking for "relief" in writing the
formulas in the first place, since a set of three formulas only differs by
one digit on the end. However, I have come to the conclusion that writing
each one from scratch is just as time-efficient as any alternative.

"Norman Jones" wrote:

> Hi KG,
>
> Since your names only differ by the last digit, having defined your first
> name, you can use this as a template for the successive names: when defining
> the second name, click on the (now) existing first name and edit the last
> digit and redefine the corresponding range.
>
> This should mean that for each successive name, you only need to type/edit a
> single character
>
>
> ---
> Regards,
> Norman
>
>
>
> "KG" <KG@discussions.microsoft.com> wrote in message
> news:8CB98020-A92F-4A01-950B-FB59056C91DA@microsoft.com...
> > 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?
> >
>
>
>

[swatsp0p]

When I find myself needing to repeatedly enter similar data, I use the copy/paste (CTRL+C, CTRL+V) to speed entry. In your example, I would make my first entry of: "CDA_GrossSales_Case1". I would then highlight and CTRL+C CDA_GrossSales_Case and CTRL+V it as needed, and simply add the last character "1", "2" or "3".

HTH

Bruce