Posted to microsoft.public.excel.programming

pauluk[_13_] pauluk[_13_] is offline

external usenet poster

Posts: 1

Copy an autofilter range

Hi all,

Does anyone know how to only copy a range whit an autofilter ha
filted:

i.e. the macro has filtered field 10 for blanks, all that is require
to be copied is the filtered rows to a sheet named "extract"

Thanks in advance
Pau

--
Message posted from http://www.ExcelForum.com

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
AutoFilter Cut/Copy not working with Name Range	NoodNutt	Excel Worksheet Functions	2	September 6th 08 11:37 PM
Insert Row/Copy with Autofilter	lilbit3684	Excel Discussion (Misc queries)	4	April 3rd 07 11:17 PM
Autofilter - copy & paste	Dorothy	Excel Worksheet Functions	0	May 29th 06 10:56 PM
What is Range For Chart AutoFilter Range VBA?	[email protected]	Excel Discussion (Misc queries)	0	April 19th 06 05:30 PM
Copy/Paste in Autofilter	honyacker	Excel Discussion (Misc queries)	2	January 12th 06 02:38 PM

All times are GMT +1. The time now is 06:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us