Filter recalculation

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

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

Don wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html