Rows in an Autofilter

Jackeb · Apr 22nd, 2002, 04:08 AM

Very simple question.... complex answer i think??

How do you fill an array with the rows that are displayed in an autofilter??

Ed

Mark W. · Apr 22nd, 2002, 07:28 AM

Advanced AutoFilter allows you to extract "filtered" data to another location.

gareth · Apr 24th, 2002, 02:28 AM

Hi there friend,Could you try the advanced filter composite
There should be many ways to do it.

Jackeb · Apr 24th, 2002, 02:29 AM

ok.... i really need to learn how to control the advanced filter anyway...!!

Cheers again

Ed

Apr 24th, 2002, 02:28 AM	#3
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Hi there friend,Could you try the advanced filter composite There should be many ways to do it. __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 04:08 AM	#1
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	Very simple question.... complex answer i think?? How do you fill an array with the rows that are displayed in an autofilter?? Ed

Apr 22nd, 2002, 07:28 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Advanced AutoFilter allows you to extract "filtered" data to another location.

Apr 24th, 2002, 02:29 AM	#4
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	ok.... i really need to learn how to control the advanced filter anyway...!! Cheers again Ed