title: VBA Excel Macro Copying One Column into Another Workbook
body: <p>I have 2 workbooks and am trying to find a way to copy a column from wb1 into wb2. I am aware I could just copy/paste, but the idea is to make something so my boss can click the macro and everything populates. </p>
  
  <p>I have been trying a code I came across in another question:</p>
  
  <pre><code>Sub Import()
  
  Dim sourceColumn As Range
  Dim destColumn As Range
  
  Set sourceColumn = Workbooks("C:\Documents and Settings\********\My Documents\*********.xlsm").Worksheets(2).Columns("BL")
  Set destColumn = Workbooks("C:\Documents and Settings\********\My Documents\*********.xlsm").Worksheets(2).Columns("A")
  
  sourceColumn.Copy Destination = destColumn
  
  End Sub
  </code></pre>
  
  <p>When I run this, I get a "Subscript Out Of Range" Error. </p>
  
  <p>The source column contains a formula relying on other columns and the destination column is empty, but even when I ran this on dummy workbooks with small digits I got the same error.</p>
  
  <p>Is there something super basic I am missing here?</p>