Macro on 2500 lines - looking to increase speed by defining variables?

Hi,

My macro is taking about ten minutes to run on 2500 lines (it's pricing an options book) - there are five variables that need to go into the calculator - is the way that they are being brought across from one spreadsheet to another the most efficient method? Any suggestions on improving the speed of the calculation? The workbook is an 11MB file with no volatile functions.

Please Login or Register  to view this content.

Thanks for looking,

LB

For what this rows

Please Login or Register  to view this content.

to make the code faster, it is necessary to use arrays and do the calculation in code, not on the sheet