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

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

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 -