FilterMode Property

See Also         Example         Applies To

True if the worksheet is in filter mode. Read-only Boolean.

Remarks

This property is True if the worksheet contains a filtered list in which there are hidden rows.