Criteria between each column Creates a LOGICAL AND condition.

You would need to use a formula in a dummy column to establish the OR
relationship and then filter on that column.

Or use an Advanced filter.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
If I want to filter the data so that any row that has a value greater than
0
in column 14 OR does not have a value of 8 in column 18... why does this
code
not work... It gives me only those rows with values less than zero in
column
14 and hides every row that does not equal 8 in column 18!

Sheets("CORPS").Select
Selection.AutoFilter Field:=14, Criteria1:="<0", Operator:=xlOr
Selection.AutoFilter Field:=18, Criteria1:="<8"

Thanks for the help