Semi-automating the generation of multiple cell range names

[SJKopischke]

We have a need for speeding up the creation of range names in a complex Excel
workbook. We know about using Insert > Name > Create for individual cells. Is
there a similar technique for ranges?

TIA

[excelent]

select range
then
Insert>Name>Define
write name>add>ok

[SJKopischke]

Um, yes. Of course.

However, I am looking for a way to automate the creation of a number of
range names, rather than taking them one at a time. Automating will help us
ensure the names are created accurately and more quickly. They can be audited
before committing them.

SJK


"excelent" wrote:

> select range
> then
> Insert>Name>Define
> write name>add>ok
>

[David Biddulph]

"SJKopischke" <SJKopischke@discussions.microsoft.com> wrote in message
news:2EBB7122-89E9-496C-AF69-02B169D19D50@microsoft.com...
> SJK

> "excelent" wrote:
>
>> select range
>> then
>> Insert>Name>Define
>> write name>add>ok

> Um, yes. Of course.
>
> However, I am looking for a way to automate the creation of a number of
> range names, rather than taking them one at a time. Automating will help
> us
> ensure the names are created accurately and more quickly. They can be
> audited
> before committing them.

If you have titles at the head of your row or column ranges, then if you use
Insert/ Names/ Create (rather than Define), it can pick up those titles &
use them as the basis for names for your ranges
--
David Biddulph

[SJKopischke]

"David Biddulph" wrote:
> If you have titles at the head of your row or column ranges, then if you use
> Insert/ Names/ Create (rather than Define), it can pick up those titles &
> use them as the basis for names for your ranges

David:

Thanks. Is there any way to programmatically reference the range itself, so
that the process can be automated further?