[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

VBA: Remembering an autofilters settings, turning it off, doing something else, then turning it back on with the original settings

Asked by eadam-uk in Microsoft Excel Spreadsheet Software

Tags: Excel, VBA

Hi All,

I have a macro which crawls through a master sheet to extract values. This works just great, apart from if you filter that master sheet, the macro will obviously only crawl the filtered values. Unfortunately the master sheet is one people will use and filter a lot.

Is there a way, I can take a snap shot of what the current filters are on the master sheet, remember them, turn them off. Then I can run my macro on the unfiltered results, then come back in at the end and turn the filter back on with the last settings?

Thanks.
[+][-]10/08/09 10:48 AM, ID: 25528033Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/08/09 11:38 AM, ID: 25528636Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625