Excel sum not updating
VBA Vault subscribers have access to the webinar on arrays and all previous webinars(see the full list). Sometimes Collections are a better option than arrays.
You may want to check out my post The Ultimate Guide To Collections in Excel VBA. The most common loops you use with arrays are the For Loop and the For Each Loop(read-only). It is used to store lists of data of the same type.
The fact that arrays use an index(also called a subscript) to access each item is important.
You can use the Array function to populate an array with a list of items. The following code shows you how to use this function.
You assign value for both array types the same way.
The number of the location is called the subscript or index.
Now that you have some background on why arrays are useful lets go through them step by step.
There are two types of arrays in VBA The difference between these arrays mainly in how they are created.