En man geant mon sandwich j'ai tenté ceci:
origine = Array("I", "J", "K", "L", "M")
Destination = Array("H", "I", "J", "K", "L")
For j = 1 To 5
Worksheets("CHIFFAFFANNUEL").Range(Destination(j) & i) = Worksheets("CHIFFAFF").Range(origine(j) & 16).Value
Next
Ca ne marche pas non plus ^^