[COLOR=#000080]Sheets("Exec. Total").Cells(ligneC, colonneC).formula = "=" & Sheets(table(0)).Cells(ligneA, colonneA).Address
i = 1
Do While i < UBound(table)
Sheets("Exec. Total").Cells(ligneC, colonneC).formula = Sheets("Exec. Total").Cells(ligneC, colonneC).formula & "+'" & table(i) & "'!" & Sheets(table(i)).Cells(ligneA, colonneA).Address
i = i + 1
Loop[/COLOR]