How can i use filter by multiple data (list) in VBA

Question

I want to use filter by multiple data in Excel VBA. at first time, I used 'for' and 'find' method, but it's too slow for processing.

In case of Python, Use the 'Pandas modules'and dataframe, Like below sample filter = dataframe['headername"].isin([Listdata1, Listdata2, Listdata3..])

but I couldn't find similar method in VBA.

Here is My background data1:

I've removed the excel-vba tag. The description fo that tag clearly says (in ALL CAPS) that the tag is pending removal and should not be used, and explains what should be used instead. Please read the description of tags before using them to make sure they're appropriate for your question. Thanks. — Ken White
– Ken White, Commented Jan 2, 2019 at 2:35
@KenWhite - I've have been wondering why the access-vba, word-vba, powerpoint-vba tag descriptions never received that 'disclaimer'? — user10852207
– user10852207, Commented Jan 2, 2019 at 3:11
@user10852207: Don't know. You might ask at Meta Stack Overflow to see if anyone does, though. There's also a link to Meta Stack Overflow in the description of the excel-vba tag after the notice that it shouldn't be used. — Ken White
– Ken White, Commented Jan 2, 2019 at 3:18

Michal · Accepted Answer · 2019-01-02 02:53:40Z

1

Sub MultiSelectFilter()

    Dim arr As Variant

    ' Range containing values to be shown
    arr = Range("C1:C3")

    ' Range to be filtered
    Range("A1").AutoFilter
    Range("A1").AutoFilter Field:=1, Criteria1:=Application.Transpose(arr), Operator:=xlFilterValues
End Sub

answered Jan 2, 2019 at 2:53

Michal

7,6744 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Heart Aim DJ Over a year ago

Thank you very much! this is that i wanted, i have a one more question, Can i filter reversed selection(invert) by modifying operator?

Michal Over a year ago

@HeartAimDJ - nope. Excluding multiple criteria is much more complex - stackoverflow.com/questions/28504517/…

Heart Aim DJ Over a year ago

That's too bad, Thank you

Collectives™ on Stack Overflow

How can i use filter by multiple data (list) in VBA

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related