Hi guys..
Need some help here...
I'm trying to have 3 criterias in 1 autofilter column but it doesnt seems to work..
This line is working fine...
Selection.AutoFilter Field:=18, Criteria1:="Current", Operator:=xlOr, Criteria2:="Past Due"
But I need to add another criteria...
Selection.AutoFilter Field:=18, Criteria1:="Current", Operator:=xlOr, Criteria2:="Past Due" , Operator:=xlOr, Criteria3:="Complete"
Why is that so?
I realise that the custom filter option only allows 2 criterias, is that the cause of it?
Thanks in advance...
:(:(