Thanks Dave,

I was not aware of the advanced filter option....the wonders of Microsoft
hiding those options you don't regularly use when you use the pull down
menus!!

Rob

"Dave Peterson" wrote in message
...
You may want to look at Data|Filter|Advanced filter and use a criteria
range.

Debra Dalgleish has some notes:
http://www.contextures.com/xladvfilter02.html

Rob wrote:

Hi,
I'd like to have more than the two criteria to filter some data, to
filter
out all those rows that contain Mr, Mrs, Miss, Dr, The, etc. etc. Is
there a
way to do something like this?
I can see that I may need as many as 8 or more.

Selection.AutoFilter Field:=1, Criteria1:="<*Mr*", _
Operator:=xlAnd, Criteria2:="<*Mrs*", _
Operator:=xlAnd, Criteria3:="<*Miss*", _
Operator:=xlAnd, Criteria4:="<*Dr*"

Rob

--

Dave Peterson