title: Method 'Range' of object '_Global' Failed error VBA when selecting Range
body: <p>So I'm using this macro to extract only the data that I need to perform a regression, and the sample set includes quite a bit of useless information for my needs. When I try to select the columns from the CCDetail workbook- I get the "'Range' of object '_Global' Failed" error. Any ideas on why this is? </p>
  
  <pre><code>Sub ExtractCCDetail()
  
  Dim WorkbookName As String
  Dim CCDetail As Workbook
  Dim Harvester As Workbook
  Dim RAWData As Worksheet
  Set CCDetail = Workbooks(2)
  Set Harvester = ThisWorkbook
  
  WorkbookName = CCDetail.Name
  CCDetail.Activate
  Set RAWData = Worksheets("Department Totals")
  RAWData.Select
      'This is where the code will break
      Range( _
          "D:D,E:E,F:F,M:M,X:X,Y:Y,Z:Z,AA:AA,AC:AC,AD:AD,AE:AE,AF:AF,BD:BD,BF:BF," _
          ).Select
          Selection.Copy
      Harvester.Activate
      Sheets.Add After:=Sheets(Worksheets.Count), Count:=1
      ActiveSheet.Name = WorkbookName
      ActiveSheet.Paste
  End Sub
  </code></pre>
  
  <p>*As a side note- I have tested doing this manually and I don't have a problem. I have also tried calling </p>
  
  <p><code>ActiveSheet.Range (wanted Range)</code></p>
  
  <p><code>RAWData.Range (wanted range)</code></p>
  
  <p>But neither of these have worked. </p>