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.