CODEWITHSUNDEEP
excelexcel-2013vba
L42
L42

Reputation: 19727

Detect autofilter on Excel Tables

Below line detects if there are active AutoFilter in a sheet.

Debug.Print Sheet1.AutoFilterMode

This returns True if there are active filters in Sheet1, False otherwise.
My problem is, this doesn't detect AutoFilter on Tables.
Is there a way to detect AutoFilterMode on Tables, a property I might have missed?

Upvotes: 1

Views: 246

Answers (1)

Tim Williams
Tim Williams

Reputation: 166316

activesheet.listobjects(1).showautofilter

will be True if the Autofilter controls are showing.

Upvotes: 3

Related Questions