autofilter true/false

  • Thread starter Thread starter Confused Individual
  • Start date Start date
C

Confused Individual

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

what is the value for autofilter?
 
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
 
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
Autofilter based on user inputbox 3
Autofilter problem 7
Advanced Filter Error - I cannot spot my Error 3
How to set range to autofiltered visible cells? 7
Help me4 2
help with highlight code 4
Eliminate blanks while copy row and transpose 11

Back
Top