VBA & Excel Lesson 3: Array vs. Collection

VBA Array vs. Collection

[ZFlyingVLover]

not a good explanation. Use arrays WHEN you're passing data over the wire like when you're sending a response across the internet from a webservice to a webservice client. WHY? Because in this scenario you have to define LIMITS to the size of the response data being sent so the recipient can be prepared to receive that size of data. Use collections WHEN you're working with lists or hashes in memory. Memory is cheap and not having to redim makes the code more maintainable. If your elements are in a collection THEN serialize/transform that collection to an array before you transmit.That's it.