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