Volatile function & Filter Show All


P

Pred

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.
 
Ad

Advertisements

Ad

Advertisements


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

Top