I saw the below code at How to automatically insert a new row and retain functions/formulas from last row?, and have a question on how to modify it so that instead of copying all content from the last row to the new one, I'd like to copy only a range of cells from the last row.// global var ss = SpreadsheetApp.getActive();function onOpen() {  var menu = [{name:Add New Last Row, functionName:addRow}];  ss.addMenu(Extra, menu);}function addRow() {  var sh = ss.getActiveSheet(), lRow = sh.getLastRow();   var lCol = sh.getLastColumn(), range = sh.getRange(lRow,1,1,lCol);  sh.insertRowsAfter(lRow, 1);  range.copyTo(sh.getRange(lRow+1, 1, 1, lCol), {contentsOnly:false});}
How to copy range from last row to a new row created via script
google spreadsheets;google apps script