Optimize for loop in order to win time

Dear all,

i am working on a huge excel document (10000 rows more than 80 columns)
I code a macro to reduce the size of the document, and it is working, the problem is that my macro is really slow to update all the datas, and i don't know (yet) how to optimize my code to win some time.

The document is quiet sensitiveBackgroung For loop optimizing.xlsx so i will just give you my code and a sample of the doc.

Please Login or Register  to view this content.

The code is working ( when the 1004 error doesn t want to show up) - please believe me.
If someone as any suggestion to win time, please don't hesitate to answer.

Thanks

Use relative references to make all your formulas in one go.

You have a whole bunch of something like

Please Login or Register  to view this content.

Instead you should do something like

Please Login or Register  to view this content.