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