[COLOR="Green"]'Copie ------[/COLOR]
Workbooks("M31-000 Demande essai VIERGE.xls").Sheets("DEMANDE").Activate
[COLOR="Red"][B] Range("I2").Select[/B][/COLOR]
Selection.Copy
[COLOR="green"] 'Recopie-----------[/COLOR]
Workbooks("M31-000 _Recap demandes.xls").Sheets("RECAP").Activate
Range("C" & x + 4).Select
ActiveSheet.Paste
Range("B2").Select
[COLOR="green"] 'Retour en feuille 1-----[/COLOR]
Workbooks("M31-000 Demande essai VIERGE.xls").Sheets("DEMANDE").Activate
ActiveSheet.Paste
Application.CutCopyMode = False
Range("D1").Select