Sub ImprimerVeterans_S()
Application.ScreenUpdating = False
Dim Ws As Worksheet
Dim MaPlage As Range
Set Ws = Worksheets("VeteransHommes")
Derlig = Ws.Range("W" & Ws.Rows.Count).End(xlUp).Row
Set MaPlage = Ws.Range("T1:Z" & Derlig)
Ws.PageSetup.PrintArea = MaPlage.Address
'.LeftFooter = ""
.CenterFooter = "Ecrire ce que je veux"
' .RightFooter = ""
Ws.PrintOut Copies:=4, Collate:=True
Application.ScreenUpdating = True
Call insertionImage_EntetePage2
End Sub