VBA Filter

[helpexcel]

Hi,

Is there a way to define the Criteria1:=Array so that it shows all items except the ones you define? So how would i define the array if i wanted to show all values except Apple, Oranges, Pears?

Thanks!

 

[Fluff]

So you simply want to filter for the values in List B, correct?

 

[helpexcel]

correct, I want to look at list A and remove all the values that aren't on list B

 

[Fluff]

Something like

   Dim Ary As Variant
   
   Ary = Application.Transpose(Range("B2", Range("B" & Rows.Count).End(xlUp)))
   With Sheets("Pcode")
      .Range("B:B").AutoFilter 1, Ary, xlFilterValues
   End With

 

[helpexcel]

Thanks!!

 

[Fluff]

You're welcome