VBA AutoFilter off Text and Cell Value Based

[ItalianPlatinum]

Hi, I have two scenarios where I am trying to solution and cant seem to get the results I was expecting

Trying to filter data based on a field not equaling 2 but the data is in text on my excel data and also filtering out a date based off a cell value

D5 =TEXT(TODAY(),"YYYYMMDD")
Today is 07/11/20 for reference

Range("10:10").AutoFilter Field:=5, Criteria1:="<>AB"
Range("10:10").AutoFilter Field:=3, Criteria1:="<>2"
Range("10:10").AutoFilter Field:=4, Criteria1:="<>Range(D5)"

Date	Date	#	Date	View Indicator
20200710​	20200710​	0	0​	AB
20200712​	20200712​	1	20200712​	AA
20200712​	20200712​	2	20200712​	AC
20200712​	20200712​	0	0​	AD

 

[Fluff]

Try

 Range("10:10").AutoFilter Field:=4, Criteria1:="<>"&Range("D5")

 

[ItalianPlatinum]

Try

 Range("10:10").AutoFilter Field:=4, Criteria1:="<>"&Range("D5")

Fluff - As usual you are the best. The one piece that still isn't working is my filter off of "2"' I think the problem resides with the data itself kicking out in text format?

 

[Fluff]

Use "<>*2*"

 

[ItalianPlatinum]

Use "<>*2*"

WORKS

 

[Fluff]

You're welcome & thanks for the feedback.

 

[ItalianPlatinum]

Ok so of course i have a variable. in that column I may have #2 and text 2. if i try this it gives me all Numbers.

Range("10:10").AutoFilter Field:=5, Criteria1:="<>2", Operator:=xlOr, Criteria2:="<>*2*"

 

[Fluff]

The best option is to clean up your data so that you either have numbers or text, rather than a mixture.