Nigel

This may help

http://www.nickhodge.co.uk/gui/viewm...m#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
HIS


"Nigel" wrote in message
...
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