Forum Discussion
Office Scripts - Clear Cell Button
Hi Jim_Currier__NPL ,
If you want to keep the formats and just clear the values inside the cells, this is an alternative code:
workbook.getActiveWorksheet().getRange('C2:C8').setValues([[""], [""],[""],[""],[""],[""],[""]])Here we are just assigning "" to all cells in the range C2:C8. There are more effective ways to write this code if you need it for more than 7 cells.
Please, test it and let me know if it works for you.
Also, the same solution can be applied in Office Scripts with the following pieces of code.
For the entire range:
workbook.getActiveWorksheet().getRange('C2:C8').clear()
For only cells C2 and C8:
workbook.getActiveWorksheet().getRange('C2').clear()
workbook.getActiveWorksheet().getRange('C8').clear()
Hi rzaneti
Still struggling for this to work, this is what i have entered;
Script seems to run with no errors, but cells do not clear.
Im all new to office scripts so bit of a learning curve.
Kind Regards,
Jim_Currier__NPL remove the "//" from your code and try to run it again. They are a comment in the code, so the Excel will ignore that line.
Hi rzaneti,
That worked, however.................
I need the formulas to stay in place and just clear data entered in the cells.
That just cleared everything.
Sorry should have said at the start.
Kind Regards,
