Select a column within a query
 

I have a worksheet that has multiple queries. Rows 6-some number (fluctuates
each week) contain the data from columns A-G.

There is another query that starts ~5 rows below the first one and goes for
another 10 or 20 rows from columns A-G again.

I need to be able to clear the contents of column F in the first query
without messing with the second one. Is there a way to select this column
inside query 1 and not the other query since the number of rows changes each
week and is not static?

Thanks.

Select a column within a query
 

if you have continous rows of data without any blank rows the use xldown

Range("F6",Range("F6").end(xldown)).clear

"Jeff Gross" wrote:

I have a worksheet that has multiple queries. Rows 6-some number (fluctuates
each week) contain the data from columns A-G.

There is another query that starts ~5 rows below the first one and goes for
another 10 or 20 rows from columns A-G again.

I need to be able to clear the contents of column F in the first query
without messing with the second one. Is there a way to select this column
inside query 1 and not the other query since the number of rows changes each
week and is not static?

Thanks.