Macro that uses "does not contain" to autofilter OUT a cells value

[davionnz]

Hi All
Iv'e searched extensively and can't seem to find how to do this.
I know how to filter based on cell value, and how to auto filter "does not contain",
but is it possible to combine these? i.e. Filter OUT the value of a cell from a range?

Appreciate your help in advance.

 

[Gavin T]

This filters cells that do not contain the value in cell A1:

ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="<>*" & Range("A1") & "*"

 

[davionnz]

Thanks Gav, will have a go with this and report back so others know if it works.

 

[davionnz]

Works perfectly. Thanks

This filters cells that do not contain the value in cell A1:

ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="<>*" & Range("A1") & "*"