Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Ottawa, Canada

    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.

    Download for FREE "vba-example-variant-variable.xls" from
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

  2. #2
    Join Date
    Nov 2007


    thanks for the post
    Peak Consulting - Business Intelligence Experts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts