Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Volatile function & Filter Show All
I have a function that returns the filter values of a specific cell filter.
My function is called like the following: =GetFilterValues("B3") 'B3' in an example, it may be any of the cell on which I have a Filter On. I put "Application.Volatile" in my code to make sure that my function is executed each time Excel recalculates my spreadsheet. This works fine but ... When I have multiple Filters set on my sheet, sometimes instead of undoing them one by one, I go to the Data menu and I select "Filter Show All". All my filters are reset but my function is not executed. I still have the result of the previous execution of my function. My function is executed only the next time I do something in any of the cells of this spreadsheet. What do I have to do to make sure my function is executed when I do a "Filter Show All" from the Data menu. By the way, I'm using Excel 2003 on Windows 2003. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Volatile function & Filter Show All
Maybe this:
http://j-walk.com/ss/excel/usertips/tip044.htm Or, this: http://www.contextures.com/xlautofilter03.html Regards, Ryan---- -- RyGuy "Pred" wrote: I have a function that returns the filter values of a specific cell filter. My function is called like the following: =GetFilterValues("B3") 'B3' in an example, it may be any of the cell on which I have a Filter On. I put "Application.Volatile" in my code to make sure that my function is executed each time Excel recalculates my spreadsheet. This works fine but ... When I have multiple Filters set on my sheet, sometimes instead of undoing them one by one, I go to the Data menu and I select "Filter Show All". All my filters are reset but my function is not executed. I still have the result of the previous execution of my function. My function is executed only the next time I do something in any of the cells of this spreadsheet. What do I have to do to make sure my function is executed when I do a "Filter Show All" from the Data menu. By the way, I'm using Excel 2003 on Windows 2003. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Volatile function & Filter Show All
Thanks for your help.
I've tried the proposed example at http://j-walk.com/ss/excel/usertips/tip044.htm and I have the same issue. When you do a Show All from the Data menu, the function is not executed. "ryguy7272" wrote: Maybe this: http://j-walk.com/ss/excel/usertips/tip044.htm Or, this: http://www.contextures.com/xlautofilter03.html Regards, Ryan---- -- RyGuy "Pred" wrote: I have a function that returns the filter values of a specific cell filter. My function is called like the following: =GetFilterValues("B3") 'B3' in an example, it may be any of the cell on which I have a Filter On. I put "Application.Volatile" in my code to make sure that my function is executed each time Excel recalculates my spreadsheet. This works fine but ... When I have multiple Filters set on my sheet, sometimes instead of undoing them one by one, I go to the Data menu and I select "Filter Show All". All my filters are reset but my function is not executed. I still have the result of the previous execution of my function. My function is executed only the next time I do something in any of the cells of this spreadsheet. What do I have to do to make sure my function is executed when I do a "Filter Show All" from the Data menu. By the way, I'm using Excel 2003 on Windows 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Today - volatile function | Excel Discussion (Misc queries) | |||
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED | Excel Worksheet Functions | |||
is MATCH a volatile function? | Excel Discussion (Misc queries) | |||
why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
Making a function somewhat volatile. | Excel Programming |