Is there a way - whether VBA or not - to clear an AutoFilter's filters but retain the sort (arrows on the AutoFilter dropdowns)?
I have read that ActiveSheet.ShowAllData does this... but when I use it, it also clears the sort, so I'm not sure what else to try?
I have read that ActiveSheet.ShowAllData does this... but when I use it, it also clears the sort, so I'm not sure what else to try?