One of Excel's fantastic features is that she calculates extremely fast and
reliable. You would need a fantastic calculation routine written in a speedy
language like C++ to get close to her performance. So I suggest you take
advantage of Excel's built-in calculation, a VBA equivalent will not do.
Well it will, but it is doomed to be far slower.

HTH. Best wishes Harald

"Cool Sport" skrev i melding
...
I have table of raw data (1000 rows and 150 columns) stored in a
worksheet. I'd like to copy them all into a 2-dimension array then do
all the calculation with this array (not the raw data on the sheet).

The calculated result will be in another array (that has the same size
or bigger). This array will be copied back into another sheet (result
sheet).

The problem is that it runs really slow when it calculates values for
every element in result array.

Please anyone can tell me how to speed up or better solution for this
issue.

All the best



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!