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.