want to speed up a loop algorithm

[freak11]

whenever i run this vba it takes 10-15 minutes. is there a way to do this quicker or do i have to upgrade my hardware? thanks

Please Login or Register  to view this content.

[mehmetcik]

You have a loop 30 to 130 so line that you can delete will save 100 actions.

You don't say if you have taken the basic steps to speed up excel.

It is good practice to run something like my Optimise subroutine before running as macro with major loops:-

Please Login or Register  to view this content.

You need to run Deoptimise to reverse its effects:-

Please Login or Register  to view this content.

You should be aware as to the affects of the above. So if you want excel to calculate a workbook during your code, don't set the calculation mode to manual.

[xladept]

See if it still works - let me know if it's any quicker

Please Login or Register  to view this content.

[mehmetcik]

This line works:

Please Login or Register  to view this content.

So Looking at your code, you can delete numerous lines :-

Please Login or Register  to view this content.