View Full Version : How to speed up VBA?

12-20-2012, 11:45 AM
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.

Kenneth Hobs
12-20-2012, 12:24 PM
Array calculations are very fast. The slow down is most likely something else. See: http://vbaexpress.com/kb/getarticle.php?kb_id=1035

12-20-2012, 06:41 PM
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


12-25-2012, 09:17 AM
Tyr this site for a few suggestions