Autofilter with string "< 12:30" where < is treated as text and not the mathematical symbol less than
How can I filter a column in an Excel file that contains strings like "< 12:30" and "< 18:00"?
I am using this script:
Workbooks(myWB).Worksheets(mySh).Range("A1:AI1").AutoFilter Field:=30, Criteria1:=Array("< 12:30")
or:
Workbooks(myWB).Worksheets(mySh).Range("A1:AI1").AutoFilter Field:=30, Criteria1:=Array(chr(60) &" 12:30")
but the character "<" at the beginning of the string is recognized as a less than symbol.
Is there a way that "<" is recognized as plain text?
