Selection.AutoFilter

resets all filters
HTH,
Gary Brown


"Ken" wrote:

Excel 2000 ... I have Filter Switches which I activate
with various recorded Macros (1 Filter Switch per
Macro) ... this is working fine as long as there is not a
Filter Switch already activated.

Above said ... I need a little Macro instruction I can
paste into my recorded Macros that will set any activated
Filter Switches back to ALL before activating the Filter
Switch I am calling for???

This so I do not get multiple Filter Switches activated by
my Macros ... Thanks ... Kha