Office Script microtutorials – copy / paste cell values
This copies value from A1 to B1:
- function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
selectedSheet.getRange(“B1”).copyFrom(selectedSheet.getRange(“A1”));
}