Autofiltering

[wasabiDev]

Hello guys, here is my code for autofiltering but it doesn't seem to work. Any ideas? is it because the criteria is a string data? i've tried Criteria1:=Array(90000*, 19000*, 11000*, 24000*) but it doesn't work. TIA


ActiveSheet.Range("$A$1:$AD$10000").AutoFilter _
Field:=17, _
Criteria1:=Array("90000*", "19000*", "11000*", "24000*"), _
Operator:=xlFilterValues

 

[Dryver14]

just to understand are you saying the number could be 900004527

 

[Joe4]

Are the actual entries in field 17 entered as Numbers or Text?

 

[Fluff]

When using Autofilter with Contains (ie an *), you are limited to 2 values only.