AutoFilter Multiple Criteria

[Takes2ToTango]

I am trying to auto filter two criteria in the same column so they can both appear. However, when I type the code in and run it, nothing appears

If ActiveSheet.AutoFilterMode = True Then
Range("C6").AutoFilter field:=2, Criteria1:=Range("D3"), operator:=xlAnd, criteria2:= Range("D3") & "Total"

I am trying to get it so that the range D3 as standard is filtered and the value of D3 plus Total on the end is filtered also.

Is there a way to wildcard a range to say if it includes D3?

 

[Muhammad_Usman]

I am trying to auto filter two criteria in the same column so they can both appear. However, when I type the code in and run it, nothing appears

If ActiveSheet.AutoFilterMode = True Then
Range("C6").AutoFilter field:=2, Criteria1:=Range("D3"), operator:=xlAnd, criteria2:= Range("D3") & "Total"

I am trying to get it so that the range D3 as standard is filtered and the value of D3 plus Total on the end is filtered also.

Is there a way to wildcard a range to say if it includes D3?

Please Share a picture of your sample data for more clarity. Thanks

 

[Peter_SSs]

Bit of a guess without seeing some sample data or the entire code, but what happens if you change the operator from xlAnd to xlOr?

 

[Takes2ToTango]

Bit of a guess without seeing some sample data or the entire code, but what happens if you change the operator from xlAnd to xlOr?

Using xlOR did the trick. How come this one worked however but xlAND didn't?

 

[Peter_SSs]

Using xlOR did the trick. How come this one worked however but xlAND didn't?

Because with And you are asking for rows where the value is the range D3 value and the value is the range D3 value & "Total". So if D3 was, say, "a" then you were trying to filter for rows that were "a" and were "aTotal". That is impossible as a row cannot be both those things.

Instead, what it seems you want are rows that are "a" or are "aTotal"

 

[Takes2ToTango]

Because with And you are asking for rows where the value is the range D3 value and the value is the range D3 value & "Total". So if D3 was, say, "a" then you were trying to filter for rows that were "a" and were "aTotal". That is impossible as a row cannot be both those things.

Instead, what it seems you want are rows that are "a" or are "aTotal"

I understand! Thank you! That makes more sense to me now

 

[Peter_SSs]

Cheers.