Semi-automating the generation of multiple cell range names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
SJKopischke said:
SJK
Click to expand...
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.
Click to expand...

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 said:
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
Click to expand...

David:

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