Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Semi-automating the generation of multiple cell range names
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Semi-automating the generation of multiple cell range names
select range
then InsertNameDefine write nameaddok |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Semi-automating the generation of multiple cell range names
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 InsertNameDefine write nameaddok |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Semi-automating the generation of multiple cell range names
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Cell address in a range | Excel Discussion (Misc queries) | |||
Combine multiple cells into one cell range. | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
macro help | Excel Discussion (Misc queries) |