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.
|