ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel VBA AutoFilter code (https://www.excelbanter.com/excel-discussion-misc-queries/262441-excel-vba-autofilter-code.html)

Isis[_2_]

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


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com