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.

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.

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.