Auto Filter. More

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

Diane 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
-----Original Message-----
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
.
Click to expand...
..
 
Hi
have a look at the Excel help file for this :-)
AutoFilterMode can only be set to FALSE. If you want to enable
autofilters you have to use the AutoFilter method
 
You must log in or register to reply here.

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

Weird ignoring of one item in a loop 5
Prevent ShowAllData Method from failing 4
AutoFilter fails 3
Autofilter - delete filtered selection 12
Protect workbook 1
Need macro to turn off AutoFilters in a table (repost) 5
Need Excel macro to turn off AutoFormat in a table 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Back
Top