title: VBA - Using Cells with Range to copy and paste
body: <p>I am beginner in VBA and am finding it hard to understand what is wrong with my below statement. To give a context of what I am trying to do, I have a source sheet (oldViewsWbk) whose cells I want to copy into my final workbook (finalViewsWbk) and then do some logic over these copied cells.</p>
  
  <pre><code>ActiveSheet.Range(Cells(2, 2), Cells(246, 2)).Value = oldViewsWbk.Sheets(1).Range(Cells(2, 2), Cells(246, 2)).Value
  </code></pre>
  
  <p>My ActiveSheet is my final workbook. For now I have hard-coded the row and column numbers, but they will be replaced by variables once I can get this working. </p>
  
  <p>I know I can use Copy and PasteSpecial to get this done, but I am wondering why this particular statement keeps throwing the error <code>'1004': Object defined or Application defined error</code>. Maybe I cant do this way at all, but I would like to know whats the reason behind it.</p>
  
  <p>Many Thanks!</p>