Advance Filter Format

J

John Smith

Hi,
I'm passing a value from a combo box to the criteria range for an
advanced filter. The problem is when I run the filter I'm not getting
the unique values. If I pass Charlie Brown and run the filter, I get
all the records associated with Charlie Brown, but I also get Charlie
Brown1, Charlie Brown2, etc. What's the proper VBA syntax to make this
work? Thanks.
James

Sub Find_It()
Sheets("Smmary").Range("A1:AP53441").AdvancedFilter Action:= _
xlFilterCopy, CriteriaRange:=Range("A1:AP2"),
CopyToRange:=Range( _
"A3:AP53443"), Unique:=True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CopyToRange to include hyperlink 0
Advance Filter data to store array 0
advanced filter office 2007 3
Fill 2 column list box with Advanced Data Filter results 1
advanced filternot working in macro 2
advanced filter date criteria 1
Coding Convention 3
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top