I agree with leinad in this one. I originally went on ahead with the offtopic since there wasn't anything better to get on with (and besides, it did get some nice information out). Looking at just one point and finding "The Best" solution for that isn't enough, you still have to look at the bigger picture. And even that "Best Solution" doesn't work for everything (and I still value fixed size growth "better" for most cases). In this case the best one would be to not use ReDim Preserve in the first place, and it can be done easily. Thus talking about the best way to increase an array with ReDim Preserve is "obsolete" at this point and would be only worthy in it's own dedicated thread. Which we don't have.

Hope we'll get a reply from the thread starter, the thread got longer than I expected very fast (and I didn't notice it until we were on the second page ). We can't help further with the optimization until we know more of what the arrays contain and what is being done.