Take a look at this:
http://www.ozgrid.com/Excel/DynamicRanges.htm

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Domenick" wrote:

I am just getting started with dynamic ranges. I have data as follows:

A B C
Product1 qty cost
Product2 qty cost
...
ProductN qty cost
TOTAL qtytot costtot

The number of products varies. There is other data below this that is
unrelated. How can I define a range dynamically that will always capture A:C
and as many rows up and including the first time it finds "TOTAL" in column A?

Any help greatly appreciated.

Thank you.