Quote Originally Posted by xld
Nested loops over that many rows and columns will take time, no matter how you tweak it.

But the design is flawed. why change everything every time? You should be using a change event just to change the affected areas. You will need to set it up once, but that minimal change as it happens.
Thank you for the reply. But, help me please, how do i "change event" in a way that make the macro run faster?

@Kenneth
Something ocurred in the paste of the text. The "." exists. Otherwise, the code couldn't run (i guess). Thanks anyway.

I would be very grateful if somebody would help me in the necessary changes to make it faster.

Thank you very much