Re : Copier coller VBA
Workbooks("Chiffre d'affaires.xls").Sheets("Rapport1").Select
'Range("A2").Select
col = 1
Do While (Cells(2, col) <> " Nom du vendeur")
col = col + 1
Loop
Workbooks("ref ntl.xls").Sheets("t").Select.Range("A2:A10000")Range(Cells(2, col), Cells(10000...