Faster code

[fulldeen]

Good morning.
I actually have to little knolegde about writing code but i really trying too hard to do so.
Here is a big part of code i wrote trying to make it work.
I dont really know how i manage to solve my problem but i wrote a very big code which i am sure
it could be done with a few lines .
Please watch the steps of the code in order to unterstand it.
As i see it takes too match time to excecute big data.
Can you please help me with that?
THANK YOU IN ADVANCED.

[torachan]

On first checking to see what range is covered.
There is something in your code that appears to be filling the range between columns "KN" to "DEI" with blank data ??????????
torachan.

[fulldeen]

thank you for your answer.
I just gave a formula to count every new column generated.

[fulldeen]

Anyone!!!!??

[sintek]

Instead of us having to follow your code...Why not explain in detail what it is you want to achieve...Add a before | after sheet scenario if need be...
Your uploaded file makes no sense...

[jindon]

See if this is what you want.

Please Login or Register  to view this content.

[ikboy]

Your code modified as below:

Please Login or Register  to view this content.

[fulldeen]

Thank you very much all of you.
That was beautiful.
I will study now and try to understand the code