royUK - my issue (as i think i have been stating) is that the code fails for me on the below line
Code
.Range("A1").AutoFilter Field:=1, Operator:=xlFilterValues, _
Criteria2:=Array(2, "3/1/2021", 2, "2/25/2021", 2, "2/24/2021", 2, "2/23/2021")
i get an error popup message box:
Microsoft Visual Basic
Run-time error '1004'
AutoFilter method of Range class failed