Sub Remplacer()
Dim noms1, noms2, i%
noms1 = Array("ColonneX", "ColonneY", "ColonneZ") 'à adapter
noms2 = Array("ColonneA", "ColonneB", "ColonneC") 'à adapter
For i = 0 To UBound(noms1)
Evaluate(noms1(i)).Clear
Evaluate(noms2(i)).Copy Evaluate(noms1(i)).Cells(1)
Evaluate(noms1(i)).Resize(Evaluate(noms2(i)).Count).Name = noms1(i)
Next
End Sub