VBA - ArrayList | Make most of VBA ArrayList
In VBA an ArrayList is a 'container' object: you can store all kinds of information in it: numbers, strings, dates, arrays, ranges, variables and objects.
VBA ArrayList is a kind of data structure we use in VBA to store the data. ArrayList in Excel VBA is a class used to create an array of values. This, unlike traditional arrays, where those arrays have a fixed length, but Array List doesn’t any fixed length.
VAB ArrayList is not part of the VBA list; rather, it is an external library or object which we need to set the reference before we start accessing it.
Arrays in VBA are an integral part of any coding language. By using arrays in excel, we can store data with a single variable name by declaring the “lower limit & upper limit.”
With regular arrays, we need to decide the lower limit and upper limit of the array. We need to decide well in advance at the time of declaring the variable in the case of Static Arrays, and in the case of Dynamic Arrays, we need to decide the length of the array after declaring the array by using the “ReDim” statement in VBA.
However, we have one more option where we can store the “N” number of values without declaring the lower limit and upper limit. In this article, we will show you about that option i.e., “VBA ArrayList.”