Forum Discussion
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...
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- 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.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
