A number of features on this site will not work properly with this browser.Please consider upgrading to the latest version of your currently used browser.



Equally, if you use VBA to read in lots of cells to memory, or write lots of data back to cells, it can be real slow. We read in 125 records at once (that's 125x20 = 2500 cells) into an array, then looped through and calculated the 14 output cells for each of these records, and stored them in a memory array.If you would like to publish your own Microsoft courseware on Courseware Marketplace, please register here and the Courseware Marketplace Publisher Team will contact you.For courseware news, subscribe to the Courseware Marketplace newsletter.(Don't use this in Excel 8, it is faster to say Range = Array). This can be done because VBA keeps variable values in memory once they are set (unless they are dimensioned within a subroutine or function, in which case they disappear when the function ends) until either you close the worksheet or make any change to the VBA code.Sub Super Blast Array To Sheet(The Array As Variant, The Range As Range) With The Range. So you can set the variables once and use them forever.