View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Isis[_2_] Isis[_2_] is offline
external usenet poster
 
Posts: 51
Default Excel VBA AutoFilter code

I am using;
Action:=xlFilterCopy, _
CopyToRange:=Range("A44"), _
Unique:=True

to copy unique names to a list - is there something I can add to this code
to strip out 'blank' entries at the same time ?

Thanks