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:
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.
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:
VBA Code:
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.