Filter is used to check specific type of data in excel workbooks. As we know excel is capable of handling thousand of records with various kind of datatype. So, it obvious to have data in text, dates, percentage and number format. These format are mainly know as datatype. We often use filter to see particular type of data in excel worksheet. While processing data using macro it is very important to check whether data is filtered on not. Sometimes, our data has some filtering criteria on excel worksheet which is not needed while running the macro for specific automation task. Therefore, it is necessary to remove filter on the data before running the macro. In this topic, we will see how we can check filter status in excel worksheet.
Here is the VBA code to check filter status in worksheet: Option Explicit Sub Check_Autofilter_Status() ' Author: Dreams24 ' Written for VBA Tricks and tips blog ' https://www.vbatricksntips.com 'Declare Variable Dim wbk as Workbook Dim sht As String
'Variable used to assign worksheet name sht="Sheet1" 'Variable set for activeworkbook Set wbk = Activeworkbook If wbk.Sheets(sht).FilterMode = False Then 'Put your code when filter is disabled MsgBox "Filter is not enabled", vbInformation Else 'Put your code when filter is enabled MsgBox "Filter is enabled", vbInformation End If Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub