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.

Bill Manville posted this:

http://groups.google.co.uk/group/mic...424cec598a2806

or

http://snipurl.com/lqav

Paul Brown wrote:

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

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

"Dave Peterson" wrote in message
...
Bill Manville posted this:

http://groups.google.co.uk/group/mic...424cec598a2806

or

http://snipurl.com/lqav

Paul Brown wrote:

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