Drop Down Filter Question

[Guzzlr]

With Range("A1:D1")[INDENT].AutoFilter[/INDENT]
[INDENT].AutoFilter field:=1, VisibleDropDown:=False
.AutoFilter field:=3, VisibleDropDown:=False[/INDENT]
[INDENT].AutoFilter field:=2, Criteria:="3"
.AutoFilter[/INDENT]
End With

Hello,
I'm having trouble with my drop down filter. It keeps faulting on Criteria:="3". How do I get Field 2 to select the number 3 from the drop down?
Thank you

 

[Dryver14]

Not to sure on the code but if 3 is the number 3 then it shouldn't be in quotes

 

[Guzzlr]

Not to sure on the code but if 3 is the number 3 then it shouldn't be in quotes

tried what you suggested, keep getting a "named argument not found" on Criteria:=3
Thanks

 

[Dryver14]

Is this a table you are working on or a series of drop downs

 

[Fluff]

it should be Criteria1:=

 

[Guzzlr]

Is this a table you are working on or a series of drop downs

Just a series of drop down. in column B, I have numbers of 1 - 22, in column D I have numbers of 23 - 33. column B I want to filter the number 3. thanks

 

[Guzzlr]

it should be Criteria1:=

Oh...I thought Criteria was the number I was trying to filter for, Are you saying Criteria 1 is Column B, because it is the first filter?

 

[Guzzlr]

[COLOR=#333333]it should be Criteria[/COLOR][COLOR=#ff0000]1[/COLOR][COLOR=#333333]:=[/COLOR]

this is working, I understand now, thank you

 

[Fluff]

Are you saying Criteria 1 is Column B, because it is the first filter?

Nope, the field is the column, but you can filter on 2 different criteria.
So you use Criteria1, for the first value to filter on & Criteria2 for the second (if you want to use both).