AutoFilter Get Criteria Array

**alexbeatle** · 11-12-2014, 02:49 PM

Good day!

I need to save\restore the AutoFilter settings.
There's a problem with multiple criteria on single column. While I can set the multiple criteria by:

Please Login or Register  to view this content.

How may I get the Criteria2 Array back into a variable?
Thank you.

**stnkynts** · 11-12-2014, 04:49 PM

I am not sure what you are asking. If you are trying to remove the values associate with an array you can simply erase the array or ReDim the elements:

Please Login or Register  to view this content.

If you are trying to remove the visual component of the autofilter you would do something like this

Please Login or Register  to view this content.

**Bernie Deitrick** · 11-12-2014, 04:50 PM

AFAIK, you cannot read the array - but you can read the visible cells of the filtered column and build up your array from that - use the array as a public variable for later reuse:

Please Login or Register  to view this content.

**alexbeatle** · 11-13-2014, 09:45 AM

Originally Posted by stnkynts

I am not sure what you are asking. If you are trying to remove the values associate with an array you can simply erase the array or ReDim the elements:

Please Login or Register  to view this content.

If you are trying to remove the visual component of the autofilter you would do something like this

Please Login or Register  to view this content.

My final goal is to save/restore Autofilter.
When I switch to Sheet2, there's a combobox associated with the filtered data - Sheet1. Since I want the combobox to include all data, I need to remove Autofilter. But when I switch back to the Sheet1, I wish the Autofilter to be back to its previous state.