Named argument not found

[Ark68]

I am attempting to filter some data with the following code ... but I get "Run-time Error 448 Named argument not found."

The autofilter is already on from a previous filtering.

With Worksheets("ALL")
     .AutoFilter Field:=16, Criteria1:="DR", Operator:=xlAnd
End WIth

 

[xenou]

Looks like this is range method, not a worksheet method (worksheets do have an autofilter property though).

Try instead:

With Worksheets("ALL")[COLOR="Red"].Cells[/COLOR]
     .AutoFilter Field:=16, Criteria1:="DR", Operator:=xlAnd
End WIth

Or instead of Cells, UsedRange or CurrentRegion or something of that ilk - not sure if this will filter all the columns or only the ones with data in it (haven't tried it lately).
ξ