VBA Developer's Handbook

the array, but all VBA does in that case is create a new data structure large enough for the new array and copy all the elements over, one by one. This isn’t a reasonable thing to do often, or for large arrays. They often use too much space. No matter how many elements you’re … ................
................