I am having an intermittent probelm with autofilter:
It is turned on and working properly. However, it will, without warning,
stop working (stop working means when I click on the drop arrow nothing
happens). If I hit the delete key, the autofiter disappears from the sheet.
I will then need to unhide the cells if necessary, then reactivate autofilter
(sometimes I need to reactivate and deactivate a few times for it to start
working). Can anyone shed some light on this, or does anyone know a fix?