ExcelBanter - autofilter true/false

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - autofilter true/false (https://www.excelbanter.com/excel-programming/291759-autofilter-true-false.html)

Confused Individual

autofilter true/false

How could I express a statement like;
If autofilter=on then...?

what is the value for autofilter?

Bernie Deitrick

autofilter true/false

Confused,

If ActiveSheet.FilterMode Then

Note that ActiveSheet.FilterMode is only True if the Filters have been
applied and are actually hiding some values in the table.

HTH,
Bernie
MS Excel MVP

"Confused Individual" wrote in message
...
How could I express a statement like;
If autofilter=on then...?

what is the value for autofilter?

All times are GMT +1. The time now is 07:27 PM.