Question Details

No question body available.

Tags

javascript excel

Answers (1)

Accepted Answer Available
Accepted Answer
January 30, 2026 Score: 1 Rep: 28,685 Quality: Medium Completeness: 40%

You need to use template literals:

let newPivotTable = workbook.addPivotTable("PivotTable1", selectedSheet.getRange(A26:AD${lastRowAD}), sheet2.getRange("A3"));

You probably also need to subtract by one when calculating lastRowAD to get the actual last-row:

let lastRowAD = colADUsed.getRowIndex() + colADUsed.getRowCount() - 1;