Optimize a code

Hi,

I have the follinwg code which runs over a very high amount of rows (45000) and it takes a lot of time for the macro to calculate all.
Is there a more efficient way of writing this code?

The code is:

Please Login or Register  to view this content.

Kind regards,

Hello Speshul,

Thanks for your quick reply.

I added those lines but it still goes very slow. As it goes step by step calculating everything it takes a lot of time for running the macro.

Regards,

What is Start and Finish?

Hi John,

Please Login or Register  to view this content.

hi pezalmendra, option (amend to your requirements if necessary):

Please Login or Register  to view this content.