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.

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.