[FONT=Arial]Sheets("Ref2").Select[/FONT]
[FONT=Arial]num_agence= Cells(lgn, 1).Value [/FONT][COLOR=teal][FONT=Arial]'on variabilise, regate = cellule ligne de la boucle, colonne 1[/FONT][/COLOR]
[FONT=Arial]Workbooks.Open ("O:\Donloar\" & num_agence &_donlar".xls")