View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Gross Jeff Gross is offline
external usenet poster
 
Posts: 64
Default 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.