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!