Re: ACTION SCRIPT RECORDER - MOVE COLUMN

Hi Jula78,

for moving the entire column C to column A using Excel Script you can try to use the following code:

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  // Cut column C on selectedSheet.
  selectedSheet.getRange("C:C").cut();
  // Insert cut cells from clipboard to A:A on selectedSheet.
  selectedSheet.getRange("A:A").insert(ExcelScript.InsertShiftDirection.right);
}

This code will cut column C to the clipboard, and then insert the cut cells to column A. This will move column C to column A without inserting a blank column in between.

To run this code, you can copy and paste it into a new ExcelScript module, and then run the module by pressing F5.

Here are the steps on how to run the ExcelScript code:

1. Open the Excel file where you want to move column C to column A.
2. Press Alt+F11 to open the Visual Basic Editor.
3. In the Insert menu, click Module.
4. Paste the ExcelScript code into the module.
5. Press F5 to run the code.