Arrays

Hi Peter, thanks for your query. Arrays are used for two purposes - to hold vastly more data than can be held on an Excel worksheet and to do things quickly. By manipulating your data in an array you leverage the processing power of the computer far more efficiently than wasting computational power and time rendering the data manipulation on the worksheet. I would head in the direction of arrays if my source data was huge and the time it took to process that data was lengthy.

There is an excellent page on arrays here, which links to a file containing some extremely useful examples:

http://www.cpearson.com/excel/vbaarrays.htm

Hope this helps,

Anthony