Make VBA Macro more efficient

Hello guys,

I am beginner on VBA and I would love if you can you please check my macro and see if there is anything you can ameliorate if there some loops to add or so and all the TCD are alike i don't knwo if i can use only one instead of 10.

thanks in advance

Please Login or Register  to view this content.

any expert there, i really need your help guys
thanks