Posted to microsoft.public.excel.misc

Isis[_2_]

external usenet poster

Posts: 51

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 autofilter change to 2003 autofilter functionality?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 10:05 PM
2007 excel autofilter change back to 2003 autofilter?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 05:53 PM
vba code on autofilter	ub	Excel Discussion (Misc queries)	1	August 6th 08 08:09 PM
Autofilter code	Dominic LeVasseur	Excel Discussion (Misc queries)	2	August 16th 06 09:33 PM
VBA code to locate cell address of AutoFilter dropdown box	Dennis	Excel Discussion (Misc queries)	3	August 9th 05 10:00 PM

All times are GMT +1. The time now is 10:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us