| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a function to test for the filters applied...
I know that you can test for the filter criteria.
Does anybody know how I can but up a filter for all of the currently applied filters, and then save it, and then have it so I can modify it? I would ideally like to save it to a macro. I know I can save to a view, but I can not modify that perse. whould I have to step through each column, then test to see if that criteria is set, and then what it is set to, then if it is set, build a string using the info? Any smoother ways of doing this? Thanks Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a function to test for the filters applied...
the autofilter has a filters collection. You can loop through that.
-- Regards, Tom Ogilvy "Phillips" wrote in message news:RT7vb.197216$275.733925@attbi_s53... I know that you can test for the filter criteria. Does anybody know how I can but up a filter for all of the currently applied filters, and then save it, and then have it so I can modify it? I would ideally like to save it to a macro. I know I can save to a view, but I can not modify that perse. whould I have to step through each column, then test to see if that criteria is set, and then what it is set to, then if it is set, build a string using the info? Any smoother ways of doing this? Thanks Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a conditional formula to increment #s in a test script | Excel Discussion (Misc queries) | |||
| Applying function after filter is applied | Excel Worksheet Functions | |||
| How to put series of number in excel while filters applied? | Excel Discussion (Misc queries) | |||
| filters how do i keep the display list empty until filter applied | Excel Discussion (Misc queries) | |||
| Can a style be applied using a function? | Excel Worksheet Functions | |||
Linear Mode
