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

Cheers
Nigel


"Dave Peterson" wrote in message
...
An alternate:

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/groups?thre...0ADE%40iies.es

Nigel wrote:

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

--

Dave Peterson