How to speed up VBA?

[arrun]

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]

Array calculations are very fast. The slow down is most likely something else. See: http://vbaexpress.com/kb/getarticle.php?kb_id=1035

[Paul_Hossler]

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

[mdmackillop]

Tyr this site for a few suggestions
http://www.decisionmodels.com/optspeedb.htm