Forum Discussion
Solved
Excel Online Script to add row with formula
Hi All, Ive got a workbook saved to a SharePoint folder. In the workbook is a script. See below. Its the part in bold i need help with. Basically the script needs to add a header to the...
- You simply add this line of code immediately below that last one:
selectedSheet.getCell(theRow, 1).setFormula("=ROW()");
Not sure I understand. How would you manually determine where to put that number 99?