use something akin to this
from
http://www.contextures.com/xlNames01.html#Dynamic
create a name (insert name define
and then
In the Refers To box, enter an Offset formula that defines the rang
size, based on the number of items in the column, e.g.:
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
In this example, the list is on Sheet1, starting in cell A1
The arguments used in this Offset function a
Reference cell: Sheet1!$A$1
Rows to offset: 0
Columns to offset: 0
Number of Rows: COUNTA(Sheet1!$A:$A)
Number of Columns: 1
Note: for a dynamic number of columns, replace the 1 with:
COUNTA(Sheet1!$1:$1)
this would create a range name for a1 to the last value in column
--
duan
-----------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...fo&userid=1162
View this thread:
http://www.excelforum.com/showthread.php?threadid=27442