Is it possible to insert a third choice in an AutoFilter through vba?
Printable View
Is it possible to insert a third choice in an AutoFilter through vba?
I have a table where the columns have autofilter. For a single column, you can only use 2 conditions for the Custom autofilter. I would like to use a third one.
Nope, it only supports 2 criterias even in Excel 2007 too.
Does this help?
http://exceltips.vitalnews.com/Pages...Filtering.html
Doesnt look like its dynamic if you have to set up some kind of criteria using conditional formatting.