title: Excel vba saving pre copied data to a variable
body: <p>Been learning vba for a while now and have managed to find and/or work out solutions to most hiccups I get into.</p>
  
  <p>However one project I'm working on at the moment raised a question.
  Essentially a chunk of data is copied from one sheet (before the sheet with the macro is even opened), the sheet I am working on is opened and the macro is run, currently what the macro does is paste the copied data and then re arrange if in the desired form. This is fine apart from the fact that the sheet is very busy and pasting the entire hunk of data has the chance to overwrite existing data in the sheet.</p>
  
  <p>Essentially I'm wondering if there is a way to save the data that has been copied to an array variable?
  I just don't know the syntax. To paste it you I just use a simple selection.Pastespecial  line, but when setting a variable you can't use that can you?</p>
  
  <pre><code>Dim pasteAr() as Variable
      pasreAr = .....??? 'currently copied data in other workbook
  </code></pre>
  
  <p>Once I've worked that out it should be simple to just paste the desired information into the sheet by referencing this array right?</p>
  
  <p>Thank for the help (in advance :P)</p>