Advanced Filter - Criteria Masking

[jim may]

I currently have my Criteria set for PROD1;
When I run it my output includes PROD1, PROD10, PROD11.

How can I limit the output to ONLY PROD1?

 

[shg]

Try =PROD1 or ="PROD1" as I dimly recollect

 

[jim may]

I tried both of these, without success, Thanks Jim

 

[shg]

Nope -- back in a sec ...

Edit: Format the criteria cell as Text and enter as =PROD1

Or leave as General and enter as '=PROD1

 

[jim may]

portion of code:

With ActiveSheet
    .Unprotect Password:="jim"
    .Range("MyData").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=.Range("B4:G6"), CopyToRange:= _
        .Range("L4:S4"), Unique:=False
    .Protect Password:="jim"
End With

 

[shg]

That doesn't set the criteria values, it just applies the filter.

 

[jim may]

Thanks SHG - That took care of it!!! Jim

 

[shg]

You're welcome.

I need to write that down someplace ...