try using a defined name for the range.
insertnamedefinecolCrefers to
=offset($c$1,0,0,counta($c:$c),1)

--
Don Guillett
SalesAid Software

"Chris Shearer Cooper" wrote in message
...
I've got a spreadsheet that loads its data from a web page as a web
query/external data range. The amount of data on the web page varies,
what
I want is to have a range (which I can then chart or whatever) that sets
itself to "all the data in column C" (for example).

How can I make the range "fit itself" to the available data? Is there
some
fancy kind of range that does this? Or, is there a way to have a macro
automatically run after the web query (and then I can make the macro do
the
right thing)?

Thanks!
Chris