Search notes:
Using Excel's AutoFilter object in the Immediate Window
The following fragments assume that a
Range is selected whose top row has the headings and whose rest contains the data to be filtered.
Filter the range on its second and fourth columns:
selection.autoFilter 2, ">10" , xlAnd, "<99"
selection.autoFilter 4, ">qqq"
Remove the condition of the second column:
selection.autoFilter 2
Modify (override) the condition of the fourth column:
selection.autofilter 3, ">yyy"
Turn off auto filtering:
activeSheet.autofiltermode= false
Just add the arrows, but don't filter anything: Turn off auto filtering:
selection.autofilter
Add a condtion in the column with a given header name:
selection.autofilter application.match("header-name", selection.rows(1), 0), ">10"