Sub Clear_Filter()
On Error GoTo whoops
Selection.AutoFilter
Exit Sub
whoops:
MsgBox "no range selected"
End Sub
Toggles AF on/off
Gord Dibben MS Excel MVP
On Thu, 26 Oct 2006 11:35:01 -0700, Pastel Hughes
wrote:
My preference, as far as shortcuts are concerned, mostly involves toolbar
buttons.
There is one to reset all filters to "Show All".
There is one to switch the Auto Filter On,
but there appears to be no Toolbar button to switch Auto-Filter off
completely.
It would make sense to me to be able to use one button to toggle the Auto
Filter.
Is there a way of creating such a button (in VB)?