Peter has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Arrays
What is the purpose of an array and how would this help my VBA code?
RE: 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
