Autofiltering and multiple selections

[GrahamButler1970]

I am looking to have more than 2 criteria in autofilter.

If you have numbers from 1 to 10 and I did not want to see the following: 2, 5, 6, 7, 9. What would the VBA code be?

I have written some code following the protocol for 2 items and it comes up with run time errors.

 

[GlennUK]

What version of Excel?

 

[GrahamButler1970]

I am using Excel 2007.

 

[GlennUK]

Specify the items to see, not the ones not to see:

   ActiveSheet.Range("$A$1:$A$20").AutoFilter Field:=1, Criteria1:=Array("1", _
        "3", "4", "8", "10"), Operator:=xlFilterValues

 

[GrahamButler1970]

Thanks for the response.

What would you do if there were potentially hundreds or thousands of items to see but never more than 5 you did not want to see.

Regards

Graham

 

[GlennUK]

Ah, that's not so easy, as far as I know. You'd need to use AdvancedFilter with criteria.

See this thread:
http://www.xtremevbtalk.com/showthread.php?t=296855