Autofilter taking too much of time
The number of rows on my xl sheet is around 40 k. i am using vba to apply autofilter inside a loop. Before applying autofilter, i use the selection.autofilter.showall.
When the code is executed, every time that the filter is reapplied, excel takes around 3 minutes to refresh. in the hintline, a "calculating" messages appears with a %.
How do we ensure that the autofilter takes less time.