extending named ranges
 

how do you extend a named range that is referred to in a formula

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

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