PC Review


Reply
Thread Tools Rate Thread

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


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