Determining Available Criteria in VBA Code for AutoFilter 
Author Message
 Determining Available Criteria in VBA Code for AutoFilter

Hi there

I have a worksheet which I regularly autofilter filter for
each unique value in column C and then copy the result of
each such filter to another worksheet. Whn I do an
autofilter, Excel automatically displays all values and I
simply have to choose each value. I would like to automate
this process with a amcro, but do not know how to
determine all the various values that I need to filter on
and once I have such values, how do I put these in a loop
as criteria for each pass of the loop.

Any help would be greatly appreacited.

Many thanks in advance.


Sat, 24 Sep 2005 04:26:14 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Custom AutoFilter in VBA

2. VBA for Excel; Getting ranges from AutoFilter

3. VBA - Excel Autofilters

4. Determine Access version from VBA code

5. VBA criteria or FIlter for sub report

6. Define query criteria through vba

7. OpenRecordSet with Criteria in VBA

8. Passing criteria to a query in VBA

9. Question about setting filter criteria in VBA

10. Type mismatch in criteria expression (VBA/Access97)

11. AppointmentItem.Items.Find (criteria) - how to specify Start and End criteria

12. How to determine if a table is available


Powered by phpBB® Forum Software