title: excel vba how to change array content by referencing array name
body: <p>I am trying to make change to the array named arraySrc in the following manner:</p>
  
  <pre><code>Dim arraySrc(0 To 1) As Integer
  
  arraySrc(0) = 1
  arraySrc(1) = 2
  Dim arrayTmp
  
  arrayTmp = arraySrc
  arrayTmp(0) = 0
  arrayTmp(1) = 1
  </code></pre>
  
  <p>Actually, I want to use one name as a handle to make change to multiple arrays individually by case, for example, I have a function to return the array name, I want to then set the returned array name to arrayTmp, then make change to arrayTmp directly using the format arrayTmp(0)=0 eg, hoping to make change to the original array </p>
  
  <p>However, by using variant doesn't work. 
  Can anybody please let me know how to implement this?</p>