by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0018 In this webinar, I cover using Arrays, Collections and Dictionaries. When should each be used? The pro and cons of each and a guide to selecting the correct one to use. Downloads Download the workbook here. Related Links VBA Arrays...
by Paul Kelly | | Data Structures VBA
The VBA ArrayList is a much better alternative to the built-in VBA Collection. It contains much richer functionality such as sorting, converting to an array, removing all items etc. Check out the quick guide for an overview of what the ArrayList does. The rest of this...
by Paul Kelly | | Data Structures VBA, Most Popular
“I’m not a builder of buildings, I’m a builder of collections” – Leonard Lauder A Quick Guide to Collections TaskExamples DeclareDim coll As Collection Create at run timeSet coll = New Collection Declare and CreateDim coll As New...