Fri, 11 May 2007 12:01:00 -0700 from Barb Reinhardt
:


" wrote:
I set my range to 10000 because I never know how many rows
I am going to import. Is there a formula that I can use that allows
me to find the end of the data in a column?

You could try something like
=sum(offset(B2,0,0,counta(B:B),1)

If you have a header in B1, it would be
=sum(offset(B2,0,0,counta(B:B)-1,1)

Barb,

Is there a variant that works when there are some empty cells within
the range?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/