script needed to find the last row and execute a copy function down

Copper Contributor

Hello everyone,

I have some large excel files with formulas that I am trying to copy down via a script and need help finding the right command (need to use online excel so NO VBA).  Here is a (greatly shortened) example of what I want to do:


Any help would be most appreciated.


3 Replies
best response confirmed by Jeff_Hunt (Copper Contributor)


That could be


function main(workbook: ExcelScript.Workbook) {
    const sheet = workbook

    const lastRowAddress = sheet

    const lastRow = sheet




Works like a champ - will plug it into the big file to test.....

Many THANKS!!!!