Running Query on a record set
 

Hi I have a spread sheet which I am opening a portion of in a record
set I would then like to do further selection on that record set is
this possible or do I have to go back to the original record set ?

Running Query on a record set
 

Hi James,

You can use the Filter method if you want to narrow down the recordset you
currently have open. If you provide more details, someone may be able to
help you further.

--
Regards,

Jake Marx
MS MVP - Excel

James Cameron wrote:
Hi I have a spread sheet which I am opening a portion of in a record
set I would then like to do further selection on that record set is
this possible or do I have to go back to the original record set ?