Sub Imprimer()
Dim fin As Double, Noms(1000) As String, I As Double
Sheets("ID").Select
fin = Range("B65536").End(xlUp).Row
For I = 2 To fin
Noms(I - 1) = Cells(CStr(I), 2)
Next I
Sheets("Rapport").Select
I = 1
While Noms(I) <> ""
Cells(1, 5) = Noms(I)
Range("A1:N45").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$N$45"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
I = I + 1
Wend
End Sub