Hi,

Problem statement:
I'm trying to set the criteria1 of a Filter but I get error message 'Object required', cannot get around it.
With Wst.AutoFilter
    With .Filters(35)
        If PRDL = Empty Or PRDL = ChrW(42) Then
            If Not .Criteria1 = "" Then .Criteria1 = ""
        Else
            If Not .Criteria1 = "=" & PRDL Then .Criteria1 = "=" & PRDL
        End If
    End With
End With
Background:
I've been using
Selection.AutoFilter field:=35, Criteria1:=MyCriteria
That works OK, but since Excel 2007 it slows down my application by much so users are complaining. So I'd like to make it faster by trying to get the above code work.
Previously my code started with switching off all filtering criterias and then setting the desired new filters.
The problem with this is that time is consumed on filters set to the same criterias than it was before. I would like the code to select which new criterias are the same and do not re-do the stting on those columns.

Goal:
There are 11 filtering criterias that are being selected by the User.
The code should go through the AutoFilter area and take each column that needs to be filtered.
Look whether the user-set filter is the same or not that is already set.
If same, do nothing, if different re-set the Criteria1.

Not sure it is clear.
Would appreciate any help.