Accessing Autofilter Lists

EricG

Guest

Posts: n/a

26th Feb 2010

Is there a way (programmatically) to access the drop down lists that are
created for each column when autofiltering is turned on? I took a quick look
at the Autofilter object of a worksheet that has autofilter turned on, but
had no luck finding anything that looked like a collection of lists.

Thanks,

Eric

« VB: Convert rectangular clusters of # within field: FindNext, Find | freeze panes from vba »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AutoFilter Dropdown Lists not working	Ray	Microsoft Excel Crashes	0	7th Oct 2008 06:16 PM
Font Size in Drop Down Lists (e.g. AutoFilter)	=?Utf-8?B?WmluZXdvd2U=?=	Microsoft Excel Misc	4	7th Aug 2008 10:12 PM
Accessing rows after AutoFilter	MartynGriffin	Microsoft Excel Programming	4	16th Jan 2006 10:05 PM
Autofilter Lists Problem	=?Utf-8?B?TWVkb3dz?=	Microsoft Excel Misc	2	15th Aug 2005 03:22 PM
AutoFilter lists unique values	=?Utf-8?B?Ui5KLkgu?=	Microsoft Excel Misc	3	19th Apr 2005 08:53 PM