Hi there,

I am trying to filter a range based on multiple OR criteria but the code I have only seems to work for two conditions. Do you know how I could include more?

I would like to filter column 6 to return any cells that contain:

1. The word 'subtotal', or
2. 'Total Fees and Service Charges', or
3. 'Description', or
4. Any blanks

Thanks in advance.

rSelection.AutoFilter Field:=6, Criteria1:=Array("=*subtotal*", "=*Description*", "=*Total Fees and Service Charges*", "="), _
                                 Operator:=xlFilterValues