View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Semi-automating the generation of multiple cell range names

"SJKopischke" wrote in message
...
SJK


"excelent" wrote:

select range
then
InsertNameDefine
write nameaddok


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