How to exclude a cell value from a table filter ?

[SlavOK400]

So i have a filtered table and a cell E1 with a city. How to exclude a cell value (E1) from a table filter ? Lets assume E1 is New York.

I can use

ActiveSheet.Range("$A$1:$D$200").AutoFilter Field:=2, Criteria1:="<>New York"

and It works BUT i have to change it every time. I tried AutoFilter Field:=Range"<>E1".Value but it doesn't work

Help me to figure it out please
Thanks.

[InvisibleMan]

Please use Code Tags. Untested, but try:

Please Login or Register  to view this content.

[SlavOK400]

Works well, Thanks!!

[InvisibleMan]

You're welcome.