Fix object model implementation of Top10 Auto Filters
The current implementation of the Top10 auto-filters in Excel is horrible.
There are four 'Top 10' filters: xlTop10Items, xlTop10Percent, xlBottom10Items, xlBottom10Percent
Problem 1) The names are deceiving. They are not always 10 items or 10 percent. Better names would be Top X Items or Top N Items.
Problem 2) The Excel object model does not allow the original criteria to be retrieved. If you create a Top 10 Items filter with the value 15, then the Filter.Criteria1 property will be changed to a >= criteria depending on the data in the column and the original value of 15 has no way of being retrieved via the Excel object model. This is a major problem for macros which want to copy filter settings from one table to another.
see 'Discovery #4: Top 10 Settings Are Weird': http://yoursumbuddy.com/autofilter-v...or-parameters/
Problem 3) The xlTop10Percent and xlBottom10Percent filters allow integer values between 1 and 500. What is 500% of a data set? It makes no sense. Perhaps decimal values between 0 and 100 would make the most sense, but at least update it to integer values between 1 and 100.