title: Excel VBA: Range of object '_Global' Failed error
body: <p>I am trying to execute the following code to copy columns from one table to another table in excel</p>
  
  <pre><code>Sub CopyData()
  '
  ' CopyData Macro
  '
  
  '
      If Application.WorksheetFunction.CountA(Range("Table13[@Budget_Line_Id]")) &lt;&gt; 0 _
      Then Range("Table13[@Budget_Line_Id]").Delete
  
      'Select desired column to copy with destination option
      Range("Table1[[@Budget_Line_Id]]").Copy _
      Destination:=Range("Table13[[@Budget_Line_Id]]")
  End Sub
  </code></pre>
  
  <p>I get a Method Range of object  '_Global' Failed error at the first line</p>
  
  <p>Could anyone please help resolving this issue</p>