Autofilter - storing parameters

[Nigel]

Hi All
Is there a method to read and save the parameters of an autofilter?

I wish to copy the selection and store the filter values with them, as a
scenario for reporting etc.

Any idesa welcome

Cheers
Nigel

 

[Nick Hodge]

Nigel

This may help

http://www.nickhodge.co.uk/gui/viewmenu.htm#Custom_Views...

The VBA example given has an example of hidden columns but it will work as
well with filtered data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Dave Peterson]

An alternate:

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/[email protected]

 

[Nigel]

Thanks for the tip, a bit of modification and I have cracked it.
It works great.

Cheers
Nigel