
4,381 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello! I have a table and I want to copy the values from cells E2:E66 and paste them into B2:B66 using an office script. However, the below code is copying and pasting the values from E2:E66 into A1:A65.
function main(workbook: ExcelScript.Workbook) {
let hardin = workbook.getTable("Hardin");
//set range on hardin
hardin.getRange("B2:B66")
// Paste range at B2:B66 from E2:E66
hardin.getRange("B2:B66").copyFrom("E2:E66", Excel.RangeCopyType.values);
}