This copies value from A1 to B1:

  • function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    selectedSheet.getRange(“B1”).copyFrom(selectedSheet.getRange(“A1”));
    }