| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extend Name range
How can I extend the name of a column range selection.
Everything is fine with my formulas with Names but when I add rows, I have to REdefine all my name range. Alex |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extend Name range
How do you currently have it defined?
-- Don Guillett Microsoft MVP Excel SalesAid Software "alex514" wrote in message ... How can I extend the name of a column range selection. Everything is fine with my formulas with Names but when I add rows, I have to REdefine all my name range. Alex |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extend Name range
If you insert rows within the range already defined by your names,
then the ranges will automatically adjust. So don't just add data to the bottom. Alternatively, you can use dynamic named ranges which will adjust automatically. Hope this helps. Pete On Feb 22, 4:57*pm, "Don Guillett" wrote: How do you currently have it defined? -- Don Guillett Microsoft MVP Excel SalesAid Software "alex514" wrote in message ... How can I extend the name of a column range selection. Everything is fine with my formulas with Names but when I add rows, I have to REdefine all my name range. Alex- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Extend Range Automatically | Excel Worksheet Functions | |||
| HOW TO EXTEND A NAMED RANGE | Excel Worksheet Functions | |||
| Painting Range - extend the range on the top part | Excel Discussion (Misc queries) | |||
| Extend a data range | New Users to Excel | |||
| Extend data range format and formulas | Excel Worksheet Functions | |||
Hybrid Mode
