Which is faster in VBA with large data sets (~110k rows): using .Find, or loading the whole thing into an array in memory and doing a for-next loop to look for the data points I need?
I ask because using .find looks like it's going to take about 16 hours to process my data set (processing ~4200 part numbers through a recursive function to traverse their bills of materials).
Thoughts?
I ask because using .find looks like it's going to take about 16 hours to process my data set (processing ~4200 part numbers through a recursive function to traverse their bills of materials).
Thoughts?