From: EricG on 26 Feb 2010 14:37
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.