Clone AutoFilter object in Excel
Posted on 2012-03-21
May I know if it is possible to clone an AutoFilter object in Excel 2010?
My purpose is this:
I have got a number of source data tables in 1 sheet. I'd like to manipulate the data filtering in the source tables in code, copying the filtered results to other sheets.
At the end, I'd like to restore the AutoFilters originally set in the source tables.