How to clear an Excel autofilter?

There are a lot of posts on various ways to set autofilter in Excel using AppleScript, but even Microsoft's Excel scripting manual doesn't tell how to turn filtering off, or the equivalent of clicking the "Clear Filter" button in the filtering UI popup panel.


set doc to active sheet

set dBase to autofilter object of doc


autofilter range (range object of dBase) field 1 criteria1 "Tuesday"

This works fine, but I can't find a way to clear the filter in order to apply a different one on a different column.

Any suggestions would be much appreciated!

Posted on Feb 22, 2016 11:20 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to clear an Excel autofilter?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.