filter the value which should not start with string

[suryu]

I want to filter the column value which should not contain string starting with "Bank", "HDFC", "SBI"

trying to do below code but not getting required results

Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")

 

[Isaac]

I think you might be limited to two criteria using that technique.
I was reading this:

filter out multiple criteria using excel vba

I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: My_Range.AutoFilter Field:=1, Criteria1:=Array...

stackoverflow.com

includes some possible workarounds.

 

[suryu]

yes that is the issue for two criteria it is working fine