If you want to check and remove if auto filter is applied on the sheet or not . Try this Code
Sub
Remove_autofilter_if_applied()
If
Sheets("sheet1").AutoFilterMode = True Then
Sheets("sheet1").AutoFilterMode = False
End If
End Sub
No comments:
Post a Comment