title: VBA to copy from one workbook and paste to another
body: <p><strong>JOB:</strong> To copy RANGE from one WORKBOOK to ANOTHER (ANOTHER workbook exists and needs to be opened)</p>
  
  <ol>
  <li><p>Copy range:</p>
  
  <pre><code>`Worksheets("paste").Range("A2:BD500").SpecialCells(xlCellTypeVisible).Copy`
  </code></pre></li>
  <li><p>Open new file:</p>
  
  <p><code>Workbooks.Open Filename:="C:\Test\test.xlsx", WriteResPassword:="WriteFile"</code></p></li>
  <li><p>Activate sheet and paste @RANGE A6</p>
  
  <p><code>Windows("test.xlsx").Activate
      Selection.Range("A6").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
          :=False, Transpose:=False</code></p></li>
  </ol>
  
  <p><strong>PROBLEM: It doesn't paste in A6!!!! It goes in whatever cell!!!!</strong></p>