Autofilter - Remember settings

[Paul Brown]

Hello all,

I have a spreadsheet which can be autofiltered at columns A, B, C and/or D.
I have created a macro which autoruns whenever column D is changed. It
removes the autofilters, sorts the data by value in column D and then column
O and then reapplies the autofilter arrows. Is there any way that the
pre-sort autofilter settings can be captured and restored when the
autofilter is reapplied? I have to remove the autofilter prior to the data
sort because the sort excludes filtered rows.

Grateful for any help.

 

[Dave Peterson]

Bill Manville posted this:

http://groups.google.co.uk/group/mi...author:manville&rnum=1&hl=en#ca424cec598a2806

or

http://snipurl.com/lqav

 

[Paul Brown]

Thanks and apologies - I did search but couldn't find anything.