As related here, Henry Plummer (John Dehner) was elected sheriff of Bannack, Montana in 1863, and very quickly the number of robberies and murders increased significantly in the area. Although it wasn't mentioned in the story, Plummer's band of road agent bandits came to be known as the 'Innocents'.
Like variables, arrays in VBA are declared using Dim. Besides the array name, you also need to specify the number and type of values the array will store. * In VBA, as in most programming languages, count starts from 0. Hence, (6) actually means that there are 7 stored values (from 0 to 6).
When you add a new item VBA automatically sets the Collection variable to a valid collection. In other words if you set the collection to nothing it will empty all the items. If you then add an item to the collection you will now have a collection with one item. The items do not have to be of the same type but they normally are. 2  The VBA Sheets collection can contain both worksheets and chart sheets. 3  A collection makes it easy to perform the same task on multiple items e.g. print all the values.