filtering for <> not a numer

[jordanburch]

Hey Guys,

I have the following

ActiveSheet.Range("$A$1:$AV$6000").AutoFilter Field:=6, Criteria1:=Array( _
"<>1110", "<>2220"), Operator:=xlFilterValues
basically I am trying to unclick the 1110 and 2220 values. its not working. can anyone help?

Jordan

 

[Fluff]

If you just have two values try

ActiveSheet.Range("A1:AV1").AutoFilter 6, "<>1110", xlAnd, "<>2220"

You can only use an array if it's an exact match

 

[jordanburch]

If you just have two values try

ActiveSheet.Range("A1:AV1").AutoFilter 6, "<>1110", xlAnd, "<>2220"

You can only use an array if it's an exact match

thanks fluff. I tried that and it says that field six is filtered but nothing is selected. I just want it to deselect 1110 and 2220. This seems to be deselecting all numbers in field six, even though it says its filtered nothing is selected, there should be several numbers selected. Any ideas?

 

[Fluff]

The code doesn't select or deselect anything, it just hides rows that equal 1110 or 2220 in col F

 

[jordanburch]

The code doesn't select or deselect anything, it just hides rows that equal 1110 or 2220 in col F

ok got ya. Its still displaying those lines for whatever reason. its not working right.

 

[jordanburch]

its almost like its deselecting all numbers in that column

 

[Fluff]

Are they actually numbers?

 

[jordanburch]

Are they actually numbers?

the formatting says general. They appear as numbers. 1110 and 2220. does it not work because they are general?

 

[Fluff]

Change the format to number with 2 decimal spaces, what do you see?

 

[jordanburch]

Change the format to number with 2 decimal spaces, what do you see?

it stays the same as 2220 and does not become 2220.00 and the code still didnt work when I changed it to a number.