try defining a name and using the offset formula
=offset($a$2,0,0,counta($A:$a),1)

--
Don Guillett
SalesAid Software

"clane" wrote in
message ...

I am trying to build a report in excel that auto updates a query from an
access database and I would like to use named ranges to make the formula
writing easier. The problem is I dont know exactly how many rows are
going to be coming in from the query each time as there is potential
for the dataset to grow.

Now i have the ranges defined as $A:$A but I am wondering if there is
a better way to do this....

Thanks in advnace for your help

Chuck


--
clane
------------------------------------------------------------------------
clane's Profile:
http://www.excelforum.com/member.php...o&userid=11865
View this thread: http://www.excelforum.com/showthread...hreadid=475122