Cells cut/paste.(Microsoft Excel Office Scripts)

03/25/2023

Japanese version.

Instructions on how to cut/paste cells in Office scripts.

Operations

Using the script record will target the active sheet, though,but the behavior changes depending on where it is launched,
It is recommended that you specify the name of the sheet. (Red text indicates variable areas).

source cell range.moveTo(destination cell range)

The following will move from cell A1 to cell E1 on the Test sheet.

function main(workbook: ExcelScript.Workbook) {
  workbook.getWorksheet("Test").getRange("A1").moveTo(
    workbook.getWorksheet("Test").getRange("E5")
  );
}

function main(workbook: ExcelScript.Workbook) {
  workbook.getWorksheet("Test").getRange("A1").moveTo("Test!E5");
}

For those who want to learn Office script effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.

Links

Office Scripts Articles

Office Scripts(Microsoft Excel)