Displaying Multiple Criteria from Autofilter

**Sinclair** · 05-19-2010, 01:14 PM

In Excel 2007 you can filter on multiple values rather than just two. However, VBA only has a Criteria2 property for a filter -- so you can't display more than two filter criterias even if you picked, for example, "1 OR 2 OR 3," etc.

Is there any way to get this data in Excel 2007? The tool tip that you see when hovering over the autofilter arrow displays just what I need, so there's some way of doing this, though it may not be accessible via VBA.

I really appreciate anyone's help. I filter many columns at the same time all day long at work and being able to quickly see the parameters would help enormously.

**Dulanic** · 05-19-2010, 02:43 PM

Technically it can only filter based on 2 criteria. What excel does it setup a array for ones that you check/uncheck items.

Example:

Please Login or Register  to view this content.

**Sinclair** · 05-19-2010, 02:55 PM

Thanks, Dulanic.

Is there a way for me to make to access the values in the array of selected filter values?

In the end, I want to display every criteria in each filtered column.

**Dulanic** · 05-19-2010, 03:12 PM

Not sure I follow, once the macro would be run, the rest would be just like if you did it by hand, it would have all the values if you used the drop down etc....

**Sinclair** · 05-19-2010, 03:17 PM

I'm trying to display the values that I've already filtered by hand -- not execute a filter that I define in the macro. I work with very large spreadsheets and, after doing all sorts of complicated filters, it would be incredibly helpful to simply run a macro and see what the "query" or total filter was rather than looking through all columns. Does that make sense?

**hujenx** · 07-09-2011, 06:10 AM

Originally Posted by Sinclair

I'm trying to display the values that I've already filtered by hand -- not execute a filter that I define in the macro. I work with very large spreadsheets and, after doing all sorts of complicated filters, it would be incredibly helpful to simply run a macro and see what the "query" or total filter was rather than looking through all columns. Does that make sense?

Did you ever succeed with this? I need to do the same.