Checking if filter is applied

**Niclal** · 12-09-2014, 07:21 AM

Hello,
I am analyzing a lot of data with Excel, and it happens very often that I get wrong results, because I forget that filter has been applied. Is there a way (a macro) to automatically check if filter has been applied and show a warning message e.g. "Filter has been applied, do you want to clear the filter? Yes / No".

Thank you for your help.
Niclal

**rajansettu** · 12-09-2014, 07:29 AM

hi niclal,

Pls check the below code
[code]
If ActiveSheet.AutoFilterMode Then
MsgBox "AutoFilter: on"
Else
MsgBox "AutoFilter: off"
End If
[\code]

Thanks

**JOHN H. DAVIS** · 12-09-2014, 07:29 AM

Maybe:

Please Login or Register  to view this content.

**Niclal** · 12-09-2014, 07:48 AM

Hi All,
This is just checking whether or not an autofilter has been applied, but not if there are some filtered columns.
Another idea is to highlight the column where a filter has been applied.
N