detect VBA autofilter

Z

Zack Barresse

Hi there,

Check the AutoFilterMode property of the worksheet object. Here is an
example...

If Sheets("Sheet1").AutoFilterMode = True Then
Msgbox "Autofilter On!", vbinformation
Else
Msgbox "Autofilter Off!", vbinformation
End if

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parapgraph Indentation 0
Help me 1 1
How can I detect change to Autofilter selection 1
Adding data to MS Access from csv file 0
Detect Autofilter Change Event 2
Re : Excel AutoFilter Detectable via the Most-Recent Activation of aFilter 0
Filtered Range VBA 2
VBA Coding Help for Beginner 0

Top