I have used all the possible techniques in Excel to improve its
performance including what you have mentioned. My computer was hung when
the first version ran. Now it takes about 10 to 70 seconds depending on
how complex the calculation formulas are.

I am using evaluate method to get the result of each formula. However,
the problem was still the same even if I avoided using this methods.

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