Sub Copie_01()
'
' Copie_01 Macro
'
'
Workbooks.Open Filename:= _
"C:\Users\Jerome\Desktop\gestion Absences ANTIN.xlsm"
'''''''''' Recopie gardes 1er Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.LAGARDE").Range("jan_1").Copy '.Select
'Range("jan_1").Select
'Selection.Copy
Range("A1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("B3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'''''''''' Recopie gardes 2eme Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.ROLET").Range("jan_2").Copy '.Select
'Range("jan_2").Select
'Selection.Copy
Range("a1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("C3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'''''''''' Recopie gardes 3eme Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.BOUTEL").Range("jan_3").Copy '.Select
'Range("jan_3").Select
'Selection.Copy
Range("a1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'''''''''' Recopie gardes 4eme Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.CHARLETTINE").Range("jan_4").Copy '.Select
'Range("jan_4").Select
'Selection.Copy
Range("a1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("E3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'''''''''' Recopie gardes 5eme Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.PERETTI").Range("jan_5").Copy '.Select
'Range("jan_5").Select
'Selection.Copy
Range("a1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("F3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'''''''''' Recopie gardes 6eme Agent ''''''''''''
Windows("Gardes UT4 2018 - Copie.xlsm").Activate
Sheets("cal.MELINE").Range("jan_6").Copy '.Select
'Range("jan_6").Select
'Selection.Copy
Range("a1").Select
Windows("gestion Absences ANTIN.xlsm").Activate
Sheets("janv_4").Select
Range("G3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B3").Select
End Sub