我一直在嘗試從中復制最后一個非空單元格Sheet1 Column A并將該單元格粘貼到Sheet2 Column D.
但是出現錯誤The coordinates of the target range are outside the dimensions of the sheet.。任何幫助將不勝感激。
function myFunction() {
const sheetName1 = "sheet1";
const sheetName2 = "sheet2";
const sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName1);
const sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName2);
const lastRow1 = sheet1.getLastRow();
const lastRow2 = sheet2.getLastRow();
sheet1.getRange("A2:A" lastRow1).copyTo(sheet2.getRange("D" (lastRow2 1)));
}
uj5u.com熱心網友回復：
解決方案：
此行試圖將多行復制到超出目標作業表尺寸的范圍，這是不允許的：
sheet1.getRange("A2:A" lastRow1).copyTo(sheet2.getRange("D" (lastRow2 1)));
由于您正在嘗試copy the last non empty cell from Sheet1 Column A and paste that cell into the last empty cell of the Sheet2 Column D，您可以使用此代碼來獲取該行：
const lastRow1 = sheet1.getLastRow();
var values = sheet2.getRange('D:D').getValues();
for (i = values.length-1; i >= 0; i--) {
if (values[i][0] == "") break;
}
const lastRow2 = i;
sheet1.getRange("A" lastRow1).copyTo(sheet2.getRange("D" (lastRow2 1));
參考：
班級范圍 | 復制到（）
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/365583.html