Extend Name range

[alex514]

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

 

[Don Guillett]

How do you currently have it defined?

 

[Pete_UK]

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