Getting an error when AutoFiltering 2 criteria

[j4ttlife]

Hey guys,

I'm trying to AutoFilter column B (in this case UK cities).

I want to AutoFilter every city not equal to London and Manchester.

The code I'm using is:

ActiveSheet.Range("A1").AutoFilter field:=2, Criteria1:="<>London", Operators:=xlOr, Criteria2:="<>Manchester"

I'm getting a Run-time error '1004': Application-defined or object-defined error.

Any pointers as to what's wrong with this line of code would be appreciated

Thanks.

 

[Fluff]

It should be Operator single.
Also you need to use And not Or

 

[j4ttlife]

It should be Operator single.
Also you need to use And not Or

Fixed, thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.