Thursday, March 10, 2005

Excel VBA Array examples

Microsoft has created a support page of examples of arrays in VBA.
I was explaining this stuff to one of my clients yesterday.
Basically an array in VBA is simply a collection of rows and columns held virtually in incrementing variables.
Eg my_array(3,5) would contain 3 'rows' and 5 'columns' of data. In total 15 pieces of data can be held in this array.
Thanks to Mark from Automate Excel for the link.