Macro to undo filters

A

Alan S

Hi Guys,

I need to write a macro that will undo all filters that
are currently on a worksheetsheet. Do I have to make
sure that all the filters are undone individually or is
there a way I can do all at the same time?

Thanks
Alan
 
D

Dave Peterson

Does undo mean remove the dropdown arrows?

activesheet.autofiltermode = false

Or just showall?

With Activesheet
If .AutoFilterMode Then
If .FilterMode Then
.ShowAllData
End If
End If
End With
 
D

Dave Peterson

In fact:

With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With

will work, too.
 
Top