title: Move an array with his headers in VBA
body: <p>So I have been trying to transfer an array from a sheet (sheet 2) to an other (sheet5) and to rename the new one so that I do not get confused using them.
  My problem is that I get all the values available in the array transfered, but I miss the headers that I want to use again on the sheet5. The code is simple but I don't know where I can add something to get the headers.</p>
  
  <p>Code :</p>
  
  <pre><code>Sheets("Equipement").Select 'Equipement is the Sheet2
  Sheets(2).Range("Tableau_equipement").Select 'Tableau_equipement is the name of the array from Sheet2
  Selection.Copy Sheets(5).Range("A5") 'pasting the array on the Sheet5.
  
  </code></pre>
  
  <p>I also add two screenshots : (the first one being the one present on Sheet2 and the second one being the results on Sheet5) :
  <a href="https://i.stack.imgur.com/EWpnD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EWpnD.png" alt="Sheet2"></a></p>
  
  <p><a href="https://i.stack.imgur.com/BufWk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BufWk.png" alt="results"></a></p>
  
  <p>Thanks for help, feel free to ask more details and excuse my poor English.</p>