Reduce Runtime For This Code

**moo5003** · 08-19-2011, 03:16 PM

Hey Everyone,

I'm somewhat new to VBA (just learned how to use it a few months ago), so any assistance would be appreciated.

I've created some VBA to cycle through risk numbers and copy paste the output for each on a seperate tab. I was hoping you guys could take a look at my code and let me know if there is anything I can do that would reduce run time. My workbook is rating insurance policies, sometimes up to 100,000 risks. Anything that would reduce runtime would be appreciated. Below is the main code, the most time consuming part would be the one For loop.

Please Login or Register  to view this content.

**snb** · 08-19-2011, 03:34 PM

Please Login or Register  to view this content.

**moo5003** · 08-19-2011, 03:57 PM

Just tried your revisions SNB. While there was an incredible difference in run time, with application.calculation=xlcalculationmanual

The rates did not change when changing risk #. It seems I'm unable to implement that portion. When I remove that piece the run time goes back to being a little sluggish.

**snb** · 08-19-2011, 04:56 PM

The rates did not change when changing risk #.

doesn't make sense to me.
If you want effective help please post a sample workbook.
I think you won't need any formulas, but can do the calulations in memory.