| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extending named ranges
how do you extend a named range that is referred to in a formula
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extending named ranges
Click on Insert | Name | Define and choose the name you want to change
- its definition will be shown in the Refers To box, so change this to suit. Alternatively, Insert enough cells within the scope of the named range, and it will automatically adjust. Hope this helps. Pete On May 5, 4:46*am, chrisbmo2000 wrote: how do you extend a named range that is referred to in a formula |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extending named ranges
Maybe...
Debra Dalgleish explains dynamic range names he http://contextures.com/xlNames01.html#Dynamic chrisbmo2000 wrote: how do you extend a named range that is referred to in a formula -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extending Look-up to multiple cell ranges | Excel Worksheet Functions | |||
| Named Ranges | Excel Worksheet Functions | |||
| Named Ranges | Excel Discussion (Misc queries) | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
Hybrid Mode
