New Chapter in Excel VBA Tutorial

We have created yet another chapter for our Excel VBA Tutorial. This chapter shows you how to create arrays in Excel VBA.


When we work with a single item, we only need to use one variable. However, if we have a list of items which are of similar type to deal with, we need to declare an array of variables instead of using a variable for each item. For example, if we need to enter one hundred names, instead of declaring one hundred different variables, we need to declare only one array. By definition, an array is a group of variables with the same data type and name. We differentiate each item in the array by using subscript, the index value of each item, for example name (1), name (2), name (3) .......etc.  


Click on the link below to learn more.


http://www.vbtutor.net/VBA/vba_chp21.htm