Filtering for multiple values VBA

  • Hello,

    I recorded this macro to have 5 filter criteria, but when I run it it only selects 3 of the 5 criteria. Can someone please assist?

    Worksheets("Sup_Data").Range("$A$1:$Q$54436").AutoFilter Field:=9, Criteria1:=Array( _
        "Contract Hrs", "Loads & Other Labor Costs", "Supervised FTE", "Total Labor Costs", _
        "Unloaded Chg Payroll"), Operator:=xlFilterValues


  • Re: Filtering for multiple values VBA

    I recorded the macro and selected those values - I realized that I have a 2nd filter on a different column that is causing it to leave only 3 of the 5 selections. Issue resolved.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!