Enter in A1:A5  a 1 2 3 4
select A1:A5
add autofilter
clear all
   note that the auto filter combo box has disappeared but checking the 
   data->filter menu shows that the auto filter still seems to exist
undo

note that the combo has failed to reappear, checking the 
data->filter menu shows that the auto filter still seems to exist

So something is wrong with the "clear" since teh autofilter is only partially disappearing. I suspect that the autofilter combo box should really be retained.