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