range name

[Guest]

I have defined a range name for a group of cells.
If I add new rows/columns, I want those cells to be included
in to the range name automatically.
Can you please let me know?

Thanks in advance.

 

[Myrna Larson]

You should INSERT new rows within the interior rather than tacking data onto
the bottom of the list. If you don't want to do that, you must define the
range name using a formula like this in the RefersTo box:

=OFFSET($A$1,0,0,COUNTA($A$1:$A$5000),3)

The range will start at A1 and extend down for as many rows as you have data
in column A (but no embedded blanks are allows) and 3 columns wide.

 

[Bob Phillips]

use a dynamic name, something like

=OFFSET($A$1,,,COUNTA($A:$A))

--

HTH

RP
(remove nothere from the email address if mailing direct)