ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Accessing Autofilter Lists (https://www.excelbanter.com/excel-programming/440027-accessing-autofilter-lists.html)

EricG

Accessing Autofilter Lists
 
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



All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com