Unanswered: 1,000,000 alculations in less than 5 seconds
Sometimes when working with large sets of data coming from central databases or accounting, sales, manufacturing programs you need so many formulas in your spreadsheets that it takes an eternity to calculate.
Here is a solution to this problem. In the spreadsheet that you can download here 1,000,000 calculations are executed in less than 5 seconds.
Discovering the VARIANT variable in VBA is as empowering as discovering SUMPRODUCT in Excel. They are the two tools that really make you a pro.