Hi,
I have a list that a user will filter, and then push a button for my VBA coding to run. The VBA then loops through the unfiltered rows. The problem I've run into is that there's so much data that Excel doesn't like the amount of noncontiguous rows.
My hope is that I can sort this list, so the data is together. The only problem is that it appears I have to unfilter the list in order for it to sort correctly. Does anyone have any coding that will record all the criteria for a filtered list, so I can then unfilter it, sort it, and reapply the filters?
Bookmarks