I have looked around the net, but cant seem to find a "reason" as to why a loop gets slower... The first 10,000 rows gets done in 3 secs, rows 80,000-90,000 takes 30 secs. Does anyone know why? I have screenupdating, displayalerts, enable events and calculation all set to false, my data is sorted as applicable, there are no objects on each loop, I use evaluate in vba, and as data is sorted any ranges are down to the minimum (basically I find the first and last row for a searched value) just cant seem to find why it slows down.
I know there may be alternatives to loops, my question is why would the loop slow down in the first place (and the way this project is going I have to use loops as requirements keep changing)? The data set is 100k rows and it runs in around 8 mins to calculate approx. 20 columns of counts, match/index etc.... Mind you them doing it manually took them 6 hours last week so still better than it was!