Auto filter using array as criteria, where some of the array is blank.

[moezaremia]

I am creating a search sheet, where the user selects which filter they want to apply using a check box and can filter for multiple terms at once. Therefore I need the criteria to be an array. But I am experiencing two problems;

1. For some reason, I can search two values in the array, but once I up it to three it stops working (ie if my array consists of just the value in B3 and B4 it works, but once I add B5 it stops working). I've tried all the filters individually and they all seem to work fine.

2. The values in the array are links to the correct cell on the work sheet, when the cell is empty it returns no values for the filter!
For instance if there is a value for B4 and B3 but nothing in cell B5, the filter returns nothing.

Here is the line

Sheets("PAWS Claims").Range("A1").CurrentRegion.AutoFilter Field:=16, Criteria1:=Array("*" & Sheets("Summary").Range("B3") & "*", "*" & Sheets("Summary").Range("B4") & "*", "*" & Sheets("Summary").Range("B4") & "*"), Operator:=xlFilterValues

I hope someone can help me trouble shoot this!

Thanks in advance

 

[moezaremia]

Ive repeated B4 twice in the code! Its just a typo and not the problem!