Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 7
Impact
~6k people reached

Nov
18
comment Search outlook emails
Any update on this? I'm facing the same issue. Its not just a indexing thing...gmail search is just smarter.
Jun
22
comment Show Excel column filter information in cells
@Sean - This is great. I tested another solution but performance was slower: If I insert 'Application.Volatile' and the start of my function as per here: stackoverflow.com/questions/11045/… then it reevaluates correctly without the extra part in the formula. Performance suffers because the excel engine doesnt seem smart enough to only re-evaluate the UDF for the range it is defined over. Your solution only runs when the filter is changed which is ideal.
Jun
14
comment Show Excel column filter information in cells
I confirmed by putting a breakpoint in the VBA that the function is only being triggered when the CheckFilters cell is modified (say by adjusting the range). Changing the filter does not trigger the function.
Jun
14
comment Show Excel column filter information in cells
Fantastic. Only issue is the update of fstate. If I change the filter, the filter string does not update. I can only seem to trigger an update by changing the CheckFilters formula in the cell. Is there some setting to force this function to evaluate when the filter is changed?