title: How do I dynamically getRange starting from a specific cell to end of sheet?
body: <p>I'm writing a script to copy down all the formulas in my sheet from the third row onwards but I don't want to change anything in my column D. I've been trying to use getRange(#,#,#,#) format but I have this error: "Cannot find method getRange(number,number,number,number)."</p>
  
  <p>I thought this error meant I was running getRange on the wrong class, but I use getRange in the same function using A1 notation and it works.</p>
  
  <p>Any help debugging this code would be appreciated. I've been working on fixing it for a few days.</p>
  
  <pre><code>function Copy_Down() {
  
    var spreadsheet = SpreadsheetApp.getActive();
    spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Data_Template'), true);
  
    spreadsheet.getRange('A3:C').activate();
    spreadsheet.getRange('A3:C3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
  
    //it breaks here:
    spreadsheet.getRange(3,5,spreadsheet.getLastRow(),spreadsheet.getLastColumn()).activate(); 
    spreadsheet.getRange(3,5,1,spreadsheet.getLastColumn()).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
  
    spreadsheet.getRange('A1:A1').activate();
  };
  </code></pre>