title: VBA Excel: Assigning range values to a new range
body: <p>I am having trouble assigning values from one workbook range to a range in my current workbook. When I assign my range using Range("A1:C1") this code works fine, however when my range is defined using Range(Cells(1,1),Cells(1,3)) the function fails:</p>
  
  <pre><code>Sub CopyRange()
      Dim inputExcel As Excel.Application, BookA As Workbook
      Path_A = ThisWorkbook.Path &amp; "\Book_A.xlsx"
      Set inputExcel = New Excel.Application
      Set BookA = inputExcel.Workbooks.Open(Path_A, ReadOnly:=True)
  
      'THIS WORKS:
      ThisWorkbook.Sheets(1).Range("A1:C1").Value = _
      BookA.Sheets(1).Range("A1:C1").Value
  
      'THIS DOESN'T WORK:
      ThisWorkbook.Sheets(1).Range(Cells(1, 1), Cells(1, 3)).Value = _
      BookA.Sheets(1).Range(Cells(1, 1), Cells(1, 3)).Value
  End Sub
  </code></pre>
  
  <p>I know this must be a simple syntax issue but I haven't been able to figure it out. How can I get the Range assignments using "Cells" to work?</p>