Extend Name range

A

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
 
P

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
 
Top