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

    Unanswered: 1,000,000 alculations in less than 5 seconds

    Hi

    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
    http://www.excel-vba.com/dforums-visitors.htm
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  2. #2
    Join Date
    Nov 2007
    Posts
    20

    good

    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
  •