Skip to Content
0
Former Member
Feb 03, 2017 at 03:12 PM

How to clear filters in Sheet (analysis for office 2.2)

1291 Views

HI Experts,

Searched blogs before posting

https://archive.sap.com/discussions/thread/3561684

I have a requirement to clear all filters which was select by user and give him freedom to select another selection

i tried for options but i dont see any option so i tried using macro but it was not working could anyone help me with these

<code>Sub Macro1()
    Cells.AutoFilter
EndSub