C Connie Apr 8, 2004 #1 how can I (with VBA) turn off the Autofilter or turn on the autofilter regardless of its current state?
how can I (with VBA) turn off the Autofilter or turn on the autofilter regardless of its current state?
D DMeade Apr 8, 2004 #2 This works for me. ws represents a worksheet, since AutoFilterMode is a worksheet property. If ws.AutoFilterMode = True Then ws.AutoFilterMode = False End If Diane
This works for me. ws represents a worksheet, since AutoFilterMode is a worksheet property. If ws.AutoFilterMode = True Then ws.AutoFilterMode = False End If Diane
C Connie Apr 8, 2004 #3 Thank you. I tried ActiveSheet.AutoFilterMode = False which seems to work OK but when I try ActiveSheet.AutoFilterMode = True it never works. Can you tell what I'm doing wrong? Thanks again, Connie
Thank you. I tried ActiveSheet.AutoFilterMode = False which seems to work OK but when I try ActiveSheet.AutoFilterMode = True it never works. Can you tell what I'm doing wrong? Thanks again, Connie
D Dave Peterson Apr 9, 2004 #4 You can turn it off that way, but you have to autofilter a range. Record a macro and you'll see the code.
You can turn it off that way, but you have to autofilter a range. Record a macro and you'll see the code.
