Search notes:
Excel Object Model: Worksheet.filterMode
ws.filterMode
evaluates to
true
if a
worksheet
contains a filtered list whose criteria hide rows.
If the filter hides rows, they can be made visible again with
ws.
showAllData
.
See also
The
autoFilter
object.
The StackOverflow question
Why does activesheet.filterMode return
false
when sheet has filter?
Index