Speed up code that inputs formulas

Hi,

This is the first time I've joined and posted to a forum, I usually search and find the answers through Google. However, I'm at a point where I cannot work out how to improve my code. This code works, its just too slow.

The code offsets down rows(approx 7000) inputting formulas as it goes, it then calculates and sets back to values. I've done some simple test by removing parts of the code, and I have identified it is the inputting of the formulas which takes about a minute to run.

Any ideas/replacement code to make this faster will be greatly appreciated.

Please Login or Register  to view this content.

Hi, the calculations are already set to manual.

Here are my Public Declerations:

Please Login or Register  to view this content.

Here are the formula's:

Please Login or Register  to view this content.

Would it be quicker to store these in an array?

Or is it the offset code which is slowing

Hi Norie,

Thanks for the reply, this did speed up a bit.

I finally found out that it was clashing conditional formatting (and probably too much) that was causing it go very slowly.

Your help was much appreciated!

Also, how do I set this thread to solved?