Sub export()
Dim Chemin As String, Fichier As String
Dim wk As Workbook
Dim feuil1 As Variant, shtpda As Variant
'*******Variable à définir**************
Chemin = "C:\Documents and Settings\peyret\Bureau\"
Fichier = "pda.xls"
'***************************************
Application.ScreenUpdating = False
Set wk = Workbooks.Open(Chemin & Fichier)
Set feuil1 = ThisWorkbook.Worksheets("Feuil1")
Set shtpda = wk.Worksheets("pda")
If feuil1.CheckBox1.Value = True Then
feuil1.Range("C2,D2,E2,F2,G2,H2,N2,S2").Copy
shtpda.Range("A1").PasteSpecial
End If
If feuil1.CheckBox2.Value = True Then
feuil1.Range("C3,D3,E3,F3,G3,H3,N3,S3").Copy
shtpda.Range("A2").PasteSpecial
End If
If feuil1.CheckBox3.Value = True Then
feuil1.Range("C4,D4,E4,F4,G4,H4,N4,S4").Copy
shtpda.Range("A3").PasteSpecial
End If
If feuil1.CheckBox2.Value = True Then
feuil1.Range("C5,D5,E5,F5,G5,H5,N5,S5").Copy
shtpda.Range("A4").PasteSpecial
End If
End Sub