'Colonne A
Worksheets("B").Cells(ligne,1).Value = ActiveSheet.Cells(ligne, 1).Value
'Colonne B
Worksheets("B").Cells(ligne,2).Value = ActiveSheet.Cells(ligne, 2).Value
'Colonne C
Worksheets("B").Cells(ligne,3).Value = ActiveSheet.Cells(ligne, 3).Value
'Colonne F
Worksheets("B").Cells(ligne,6).Value = ActiveSheet.Cells(ligne, 6).Value
'Colonne G
Worksheets("B").Cells(ligne,7).Value = ActiveSheet.Cells(ligne, 7).Value