FilterMode Property

See Also                  Applies To

True if any worksheet rows are currently hidden by AutoFilter criteria. The default value is False. Read-only Boolean.

Remarks

If the Auto Filter drop-down arrows are visible but no rows are currently filtered (all rows are visible), the AutoFilterMode property is True and the FilterMode property is False.