Sub Macro1()
Source = Array("a6", "c2", "e7") ' Déclaration tableau source
Destination = Array("n10", "b12", "a33") ' et destination
For i = 0 To UBound(Source) ' Les tableaux commencent en 0, Ubound donne la fin
Range(Destination(i)) = Range(Source(i)).Value
Next
End Sub