ExcelBanter - View Single Post

dan

thanks Duane, worked great.
-----Original Message-----

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 range
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 a

--
duane

----------------------------------------------------------
--------------
duane's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=274421

.