Single Cell Web Query

[Scott]

When performing a web-based query it seems that the entire table is imported-
however, I'm only interested in the data in a single cell. Is there a way to
do this?

 

[Don Guillett]

Don't think so. You can always hide columns/rows if ALWAYS in the same place
or copy elsewhere with a macro. Post your url and I'll take a look

 

[Dave Peterson]

I don't do much with queries, but couldn't you put the results of the query on
its own worksheet, then just retrieve the value you want?