Prev: Excel VBA AutoFilter code
Next: forgot to attach doc sent via email, original's not saved. canit.
From: Isis on 26 Apr 2010 12:34
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
 | 
Pages: 1
Prev: Excel VBA AutoFilter code
Next: forgot to attach doc sent via email, original's not saved. canit.