Copy and Paste Data Range

Copy and Paste Data Range

function CopyToFunction() {

  const ss=SpreadsheetApp.getActiveSpreadsheet();

  const sh=ss.getSheets()[0];

  //sh.getRange('A1:C5').copyTo(sh.getRange('E1'), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);

  sh.getRange('A1:C5').copyTo(sh.getRange('E1'), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);

  //sh.getRange('A1:C5').copyTo(sh.getRange('E1'), SpreadsheetApp.CopyPasteType.PASTE_FORMULA, false);

  //SpreadsheetApp.CopyPasteType.PASTE_NORMAL

}