79648585

Date: 2025-06-02 10:46:50
Score: 3.5
Natty:
Report link

Thanks, this script works. Sheet1.Range("$A$1:$B$8").AutoFilter Field:=1, Criteria1:=Array( "=< 12:30", "=< 18:00"), Operator:=xlFilterValues

But I have 1 more problem, I have data as per the attached image, the data shows the time range with the code "< 12:00", "< 18:00", "< 24:00", "> 24:00" and Blank, how to do it if I want to select other than "< 12:00".

Thanks.

enter image description here

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Blacklisted phrase (1): enter image description here
  • RegEx Blacklisted phrase (1): I want
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Rahmad Zain