Auto filter criteria

[Craig1]

Hi Guys,
I have been scratching my head over this for a couple of hours, can it be done.
I have the code below

Selection.AutoFilter Field:=13, Criteria1:="In progress", Operator:=xlAnd

What I also need the code to do is as well as "In progress" in the same column I want it to filter "Not started".

I tried:-
Selection.AutoFilter Field:=13, Criteria1:="In progress" & "Not started", Operator:=xlAnd
and a few other variations but all to no avail, can it be done????

Any help would be appreciated.

Craig.

 

[VoG]

Try

Selection.AutoFilter Field:=13, Criteria1:="In progress", Criteria2:="Not started", Operator:=xlAnd

 

[Craig1]

Thanks for the quick reply Peter.

That was one of the variations and it didn't work, but thinking I had a comma missing or something like that I tried again and still no joy. It just shows a blank.

Craig.

 

[VoG]

Perhaps

Selection.AutoFilter Field:=13, Criteria1:="In progress", Criteria2:="Not started", Operator:=xlOr

 

[Craig1]

Thanks Peter, that worked perfectly.
What is the difference between
Operator:=xlAnd
and
Operator:=xlOr

Is it simply as it looks "and" or "or"

Craig.

 

[VoG]

Yes, exactly. That's why you got no records originally since you wouldn't have both phrases in a cell at the same time. I should have spotted that