It does not need to be dimensioned before use like an Array. The ArrayList object expands and contracts in size according to how many items that it contains.Once values have been added, the indexed value cannot be changed, whereas on an Array List, editing is possible. The Collection object only has two methods (Add, Remove) and two properties (Count, Item) whereas an Array List has many more.Let’s discuss some difference between ArrayLists and Collections and Arrays. It is similar to a Collection object, but it has far greater flexibility from a programming point of view. Array List Methods Summary for Excel VBAĪn ArrayList is a VBA object that can be used to store values.Copying a List Array into a Worksheet Range.Copying a List Array into a Conventional VBA Array Object.Searching for Items Within an Array List.Reading / Retrieving a Range of Items from an Array List.

Adding an Array of Values to an Array List.Editing and Changing Items in an Array List.Populating and Reading from Your Array List.Distributing Your Excel Application Containing an Array List.

Visual basic for excel array