ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autofilter (https://www.excelbanter.com/excel-programming/401966-autofilter.html)

Angeles

Autofilter
 
How can I set as not active the auto filter ?

WHA

Autofilter
 
On Nov 29, 6:55 pm, Angeles wrote:
How can I set as not active the auto filter ?


I believe it's

MyWorksheet.AutoFilterMode = False

Try Excel help on FilterMode and AutoFilterMode.

Angeles

Autofilter
 
It worked !

Now ... how can I activate it again ?

"Angeles" wrote:

How can I set as not active the auto filter ?



All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com