Posted to microsoft.public.excel.misc

Isis[_2_]

external usenet poster

Posts: 51

Excel vba autofilter code

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

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 VBA AutoFilter code	Isis[_2_]	Excel Discussion (Misc queries)	0	April 26th 10 05:31 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 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us