Worksheet.FilterMode (Excel)

True if the worksheet is in the filter mode. 


Dim booFilterMode As Boolean
booFilterMode = ActiveSheet.FilterMode