I've got a column of operators (=, <, >, <=, >=) and I'm trying to autofilter the data in VBA excel with the following code:
Activesheet.range("A:BB").AutoFilter Field:=23, Criteria1:="<", operator:=xlFilterValues
I'm trying to filter the data to only show the rows with < in the specified column but I can't get it to work. After the code runs, it shows this column as filtered but none of the filtered boxes are checked and it hides all of my data. I've tried doing the macro recorder and that is the exact code it spits out, but when I try running it in VBA it runs but doesn't work at all (hides all data).
Any help on this would be appreciated, thank you in advance!
Bookmarks