Unanswered: Identify the Criteria current in an AutoFilter
Happy New Year!
I was wondering if it is possible to identify is an autofilter as any filters applied and if so what filter is being applied.
I have a spreadsheets that has several filters. I need to check if any of the filters are being used and if so turn it off, do something with the spreadsheet, and then reset the filter to its original setting.
at the moment I just turn the filter of and on using
Selection.AutoFilter Field:=4, Criteria1:="help"
but what if the filter was on "please"?????