I'm using the following script in order to copy data from one sheet to another in the same spreadsheet with values only and in a specific cell.

My problem is that the range to copy had to be updated by 2 more columns but now the script is not correctly working. When I check the sheet where the values are copied, I'm missing the 2 new columns somehow. I already make sure that the range specified in the code is the one I want.

I would really appreaciate your help. Thank you!!

function copyANDpaste() {
   var spreadsheet = SpreadsheetApp.getActive();
   var originSheet = spreadsheet.getSheetByName('Sheet1');
   var listToCopy = originSheet.getRange('B9:AN26');
   var destinationSheet = spreadsheet.getSheetByName('1st Week');
   var destinationColum = destinationSheet.getLastColumn();
   listToCopy.copyTo(destinationSheet.getRange('B2'),{contentsOnly:true});
};