Excel vba autofilter code

I

Isis

I have some code to filter a result set to a list of unique names - is
there something I can add that will also remove 'blank' entries ?

Range("AP1:AP" & LastRowNewData).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=Range("A44"), _
Unique:=True


Thanks
 

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

Excel VBA AutoFilter code 0
relative destination for advance filter results 1
xlfiltercopy and formatting 0
Filter and copy question 3
macro add 10
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Advance Filter Format 0
Advance Filter data to store array 0

Top