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.