Office Script for auto fill to last row of adjacent column

[boxboxbox]

I'm trying to make an automate script for my worksheet and having problems with the autofill function. I have 2 columns of data A and B...i have a formula (=TEXTJOIN(", ",,A2:B2) at the top of column C (cell C2) that i would like to have fill down to the last row of data from column B. The number of rows changes each time i need to run the script, so i can't set a specific range.


Essentially I am looking for the script that is equivalent to double clicking the bottom right corner of a cell to make the data auto fill down.

I didn't even know scripts existed until 2 days ago so i am very new to this

 

[ExcelToDAX]

How about:

function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    selectedSheet.getRange("C2").setFormulaLocal("=TEXTJOIN(\", \",,A2:B2)");
    let lastRow = selectedSheet.getUsedRange().getLastRow().getRowIndex() + 1;
    let rng = "C2:C" + lastRow;
    selectedSheet.getRange("C2").autoFill(rng, ExcelScript.AutoFillType.fillDefault);
}

 

[MARK858]

Deleted as read it as vba code rather than Office Script (should have read the title properly)

 

[boxboxbox]

thank you, that worked! But what if I wanted to auto fill another column beside it? or 2? or 5? it worked with the first (column C) when i change the cell references, to use the next few columns i get an error

 

[boxboxbox]

How about:

function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    selectedSheet.getRange("C2").setFormulaLocal("=TEXTJOIN(\", \",,A2:B2)");
    let lastRow = selectedSheet.getUsedRange().getLastRow().getRowIndex() + 1;
    let rng = "C2:C" + lastRow;
    selectedSheet.getRange("C2").autoFill(rng, ExcelScript.AutoFillType.fillDefault);
}

thank you, that worked! But what if I wanted to auto fill another column beside it? or 2? or 5? it worked with the first (column C) when i change the cell references, to use the next few columns i get an error

i've fixed the redeclare error by changing the 'last row' to 'bottomrow' and similar for the others and that went away. but now i'm getting a new error...

 

[MARK858]

@boxboxbox shouldn't autofit(rng, in your last image be autofit(rang,
and "D2:D" + LastRow be "D2:D" + bottomRow

 

[ExcelToDAX]

You are filling out Cell D1 and Filling it down from D2. Isn't D1 supposed to be D2, or is that the column header? Also at the bottom of your code you are still referencing rng when it should be rang like @MARK858 said as well as the bottomRow instead of LastRow