title: assign one array to another in vba
body: <p>In my project I work with arrays a lot and I would like to find a way to assign the return value of one function (which is array) to another newly declared array. I searched and found a way which suggests that I split the array and the rejoin it into another, but I would like a more precise way of handling this requirement...
  Let's say the function that is going to return the value:</p>
  
  <pre><code>Public Function GetVariables() As String()
  Dim Vars() As String
  GetVariables = Vars       
  End Function
  </code></pre>
  
  <p>and the function using it:</p>
  
  <pre><code>Public Function popu()
      Dim Vars() As String
      Set Vars = GetVars()
  End Function
  </code></pre>
  
  <p>but this gives me an error:</p>
  
  <pre><code>can not assign to array
  </code></pre>
  
  <p>i would be very grateful of your sincere help.</p>