Excel and coding newbie here.
Trying to record an automation to auto fill column F, until the last row in column E e.g., select F2 formula and double click on the little green square. Column F is not always 20 long, it depends on last row in column E. Sometimes more, sometime less. Below is part of the code from the Excel Code Editor window. Any advice would be greatly appreciated! Thank you.
// Set range F2 on selectedSheet
selectedSheet.getRange("F2").setFormulaLocal("=TEXT(E2,\"mm/dd/yyyy\")");
// Auto fill range
selectedSheet.getRange("F2").autoFill("F2:F20", ExcelScript.AutoFillType.fillDefault);
Trying to record an automation to auto fill column F, until the last row in column E e.g., select F2 formula and double click on the little green square. Column F is not always 20 long, it depends on last row in column E. Sometimes more, sometime less. Below is part of the code from the Excel Code Editor window. Any advice would be greatly appreciated! Thank you.
// Set range F2 on selectedSheet
selectedSheet.getRange("F2").setFormulaLocal("=TEXT(E2,\"mm/dd/yyyy\")");
// Auto fill range
selectedSheet.getRange("F2").autoFill("F2:F20", ExcelScript.AutoFillType.fillDefault);