Hi,
It'd be extremely useful for me if I could push values to an already existing array which I can dynamically resize.
I understand about ReDim, and I wrote a little subroutine which does what I want. However, it's making my code run really slowly:
Is it the case that ReDim actually copies the whole of the array to a different location every time you do it? So the more times you call a sub like the one that I listed above, the slower it gets. Is there some way around this?Please Login or Register to view this content.
I heard Collections might be a solution to this, but I don't really know much about them.
Many thanks!
Bookmarks