Hi All,

I am using the following code to apply a filter to a spreadsheet:-

Selection.AutoFilter Field:=7, Criteria1:="High", Operator:=xlOr
Criteria2:="Low"

I can only work out how to filter by two criteria. Is there a metho
that would allow me to filter by 3 criteria, i.e. display all item
which are either, High, Low or Medium?

Any help would be gladly received.

And

--
andibeva
-----------------------------------------------------------------------
andibevan's Profile: http://www.excelforum.com/member.php...nfo&userid=988
View this thread: http://www.excelforum.com/showthread.php?threadid=26459

Hi andibevan

My new Add-in have 5 options
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"andibevan" wrote in message ...

Hi All,

I am using the following code to apply a filter to a spreadsheet:-

Selection.AutoFilter Field:=7, Criteria1:="High", Operator:=xlOr,
Criteria2:="Low"

I can only work out how to filter by two criteria. Is there a method
that would allow me to filter by 3 criteria, i.e. display all items
which are either, High, Low or Medium?

Any help would be gladly received.

Andy


--
andibevan
------------------------------------------------------------------------
andibevan's Profile: http://www.excelforum.com/member.php...fo&userid=9882
View this thread: http://www.excelforum.com/showthread...hreadid=264599