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

Thanks!

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.