I need to write a filter criteria with 3 conditions. It seems like m
code doesn't work for 3 criterias. Can somebody help me?

Selection.AutoFilter Field:=12, Criteria1:="=P01", Operator:=xlOr
Criteria2:="=P02", _
Operator:=xlOr, Criteria3:="=BPBT"

Thanks a lot!

Regards

--
Message posted from http://www.ExcelForum.com

Autofilter does not support 3 criteria - only two. You could create a dummy
column that has a formula like

=if(or(C2="P01",C2="P02",C2="BPBT"),"Show","No Show")

then drag fill that down the column and filter on that column.

If P01 and P02 are the only entries that start with P, you could use two
criteria
Critera1:="=P*"
Criteria2:="=BPBT"

--
Regards,
Tom Ogilvy

"desmondleow" wrote in message
...
I need to write a filter criteria with 3 conditions. It seems like my
code doesn't work for 3 criterias. Can somebody help me?

Selection.AutoFilter Field:=12, Criteria1:="=P01", Operator:=xlOr,
Criteria2:="=P02", _
Operator:=xlOr, Criteria3:="=BPBT"

Thanks a lot!

Regards!


---
Message posted from http://www.ExcelForum.com/