VBA: Excel Autofilter - Looping through dropdown values for 5 fields
Posted on 2010-09-08
I have 5 fields for which I need to loop through via Autofilter and apply a function I wrote.
I attempted this using the scripting.dictionary. The problem I came across with is, even though the 5 scripting dictionary (for the 5 fields) were unique, certain combinations returned no rows and 5 colums by 10928 rows...i stopped the code after 3 minutes. Not usuable in this business setting.
I tried creating logic to go around this by at the 3rd field, it's already proving to be a daunting task and I'm here to ask if there's an easy way around this?