Sub copiecolonne()
Dim Réponse As Integer
Réponse = MsgBox("Voulez-vous copier sur Facture ? (sinon ce sera Devis)")
If Réponse = vbYes Then
Workbooks.Open Filename:= _
"\\FACTURATION - FACTURES\MODEL FACTURE.xls" _
, UpdateLinks:=0
ThisWorkbook.ActiveSheet.Columns("A:F").Copy Sheets("ORIGINAL").Range("A1")
Else
Workbooks.Open Filename:= _
"\\FACTURATION - FACTURES\MODEL DEVIS.xls" _
, UpdateLinks:=0
ThisWorkbook.ActiveSheet.Columns("A:F").Copy Sheets("ORIGINAL").Range("A1")
End If
End Sub