Forum Discussion

Copper Contributor

Dec 20, 2022

Problems with Multiple Filter in Macro

Hi, I am facing issues when filtering for multiple things in my Macro. I am filtering on three different criteria's but when clicking the button I have created, instead of filtering all lines g...

excel

HansVogelaar

MVP

Dec 20, 2022

RonnieGK

AutoFilter does not sort data but filters them, i.e. it hides all rows that don't meet the specified criteria.

Try this:

Sub Sorter_Dato()
    Range("A13:AA2758").Sort _
        Key1:=Range("Y13"), _
        Key2:=Range("AA13"), _
        Key3:=Range("Z13"), _
        Header:=xlYes
End Sub

RonnieGK

Copper Contributor

Dec 20, 2022

Hi, I was meaning filtering and writing sorting.

I want to filter for three different things as described in the code and my post.
But after running macro, all lines go away not only according to the filter criterias.

I then have to go to text Filters -> Custom Filter and press "OK", on all three columns I want to filter. Then it shows the content I need.