Code Optimisation - Run Speed

[swizard]

Hey everybody.

I have a spreadsheet that simulates mixing across a series of mixed vessels. The equations defining each vessel are connected, creating a circular reference so I have enabled iterative calculation in the workbook.

The attached code generates data to go into a chart by evaluating each function at time (t) = 0 to 120. Since the output cell is a formula, I used paste special / paste values to get the actual number at each t.

In essence, the code preforms the Copy / Paste loop 360 times. Is there an alternative method of writing this to speed up the execution of the macro? I can edit the workbook to upload it if necessary.

Thanks in advance.

Please Login or Register  to view this content.

[tehneXus]

try

Please Login or Register  to view this content.

[swizard]

Ignore me, teheneXus that's perfect.