Filter recalculation

[Don]

Is there any way to automatically force an advanced filter to recalculate
when everything else does? If not, is there a simple way to force a filter
recalculation?

The only way I see to force an advanced filter to recalculate is too
basically redefine it.

Thanks

 

[Debra Dalgleish]

You could use an event procedure to run the macro if the data changes.
Chip Pearson has information on his web site:

http://www.cpearson.com/excel/events.htm

Or, record a macro as you run the advanced filter. Add a button to the
worksheet, and assign that macro. Then, click the button when you want
to run the advanced filter. David McRitchie has information on his web
site:

http://www.mvps.org/dmcritchie/excel/getstarted.htm