| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter true/false
How could I express a statement like;
If autofilter=on then...? what is the value for autofilter? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
autofilter true/false
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 "Confused Individual" wrote in message ... How could I express a statement like; If autofilter=on then...? what is the value for autofilter? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(test,true,false) only ever returns "true"? | Excel Worksheet Functions | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Hybrid Mode
