Option Explicit
Sub testX()
Dim colonne, SH, A&, MsG$, LiG&, RnG, TotaL&, TabLresulT, I&
colonne = Array( 2, 3, 6, 7, 1, 10, 1, 9) 'matrice de colonne
Sheets("All_Name").Cells.Clear ' vide la feuille All_Name
DoEvents
Application.ScreenUpdating = False
For I = 13 To Sheets.Count...