Wild Card in Autofilter

[stapuff]

I am using a wild card in the section of autofilter code below. This works well but I need to change it from --> Criteria1:="=Z*" to all Z* except ZW. How can this be done still using the wild card or will I need to specify through multiple filters ZA:ZV & ZX:ZZ keeping just ZW?

Thanks,

Kurt


Set rng = Range("A1:K" & Range("A5000").End(xlUp).Row)
rng.AutoFilter Field:=1, Criteria1:="=Z*"
On Error Resume Next
With rng
rng.Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete
End With
Err.Clear
ActiveSheet.AutoFilterMode = False
Set rng = Nothing

 

[Norie]

Add a second criteria.

rng.AutoFilter Field:=1, Criteria1:="=Z*", Operator:=xlAnd, _
        Criteria2:="<>ZW"

 

[stapuff]

Norie -

Thanks for pointing that out. I and tried the second criteria - I used xlor not and. Thanks again for the post.

Kurt