Home |
Search |
Today's Posts |
#1
|
|||
|
|||
range name
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. |
#2
|
|||
|
|||
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. On Mon, 28 Feb 2005 22:27:02 -0800, "P.hamsa" wrote: 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. |
#3
|
|||
|
|||
use a dynamic name, something like
=OFFSET($A$1,,,COUNTA($A:$A)) -- HTH RP (remove nothere from the email address if mailing direct) "P.hamsa" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions |