Dear all, I have a very large array in my VBA code and felt that calculation is really slow.
So is there any trick to speed up calculation in VBA? Should I use C to handle computationally intensive portion of my code?
Thanks for your input.
Dear all, I have a very large array in my VBA code and felt that calculation is really slow.
So is there any trick to speed up calculation in VBA? Should I use C to handle computationally intensive portion of my code?
Thanks for your input.
Array calculations are very fast. The slow down is most likely something else. See: http://vbaexpress.com/kb/getarticle.php?kb_id=1035
I'd suggest that -- since you have the data in an array -- then either
1. You have a LOT of data
2. You have loops within loops within loops ....
3. Your algorithm is not very effecient
Without seeing the code, the only sure fire solution would be to buy a faster computer
Paul
Tyr this site for a few suggestions
http://www.decisionmodels.com/optspeedb.htm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'