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
Selection.AutoFilter Field:=4, Criteria1:="help"
but what if the filter was on "please"?????

To check whether there are any autofilters on a sheet:

test = ThisWorkbook.Worksheets("sheet1").AutoFilterMode

To check whether a particular autofilter is being used:

test = ThisWorkbook.Worksheets("sheet1").AutoFilter.Filte rs(1).On

To get the criteria for that filter:

test = ThisWorkbook.Worksheets("sheet1").AutoFilter.Filte rs(1).Criteria1

Thank you very much this worked fine.