randomuser
New Member
- Joined
- Jul 22, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I have a large table with 5 search options with only 4 working correctly. The one that is not working correctly filters with 0 results and then gets stuck there, where it doesn't turn off the filter when I remove the text in the search field. Two of the search boxes are for columns of letters and two are for columns with a mixture of letters of numbers, and they both work perfectly. The non working column is a list of four and five digit numbers. When I change just the field number in the formula it works. When I swap one of my working search boxes to read that column, it no longer works. I've changed the format to number in both the source table and reference cell for the search box, but no luck. Any ideas what I'm missing? Is there something I should add to the formula to tell it to read it correctly?
Private Sub v2_Change()
Application.ScreenUpdating = True
ActiveSheet.ListObjects("data").Range.AutoFilter Field:=31, Criteria1:="=*" & [P1] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
Private Sub v2_Change()
Application.ScreenUpdating = True
ActiveSheet.ListObjects("data").Range.AutoFilter Field:=31, Criteria1:="=*" & [P1] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub