Code to manipulate Excel's Autofilter 2

[SteveMersereau]

I need to write some code to save the current Autofilter state, then clear all filters, then do some stuff I've already written, then, finally restore the original autofilter state.

All help appreciated!

Steve

"In the Jungle of the Senses

 

[Chance1234]

Take a look at the help file and look up Advanced Filter.

You can then use VBA to save/change/delete the criteria in the cells which is pretty straight forward,

Chance,

Filmmaker, gentlemen and explorer

http://WWW.HOWTOBESPOOKY.CO.UK

 

[xlbo]

The help file for the Autofilter OBJECT has an example that does exactly what you ask

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[DaleWatson123321]

Steve,

I can email you an example file I developed that has 7 buttons (with code attached) that allow for data manipulation such as:
- Filtering in place,
- Deleting filtered records,
- Extracting records
- Showing all records

The file also demonstrates how to properly set up the criteria for filtering and extracting data, including notes within the file.

I hope this will help

Regards, Dale Watson dalwatson@gov.mb.ca

 

[SteveMersereau]

Thanks to everyone.

Job done!

Steve