Forum Discussion
Solved
Office Scripts - Clear Cell Button
Hi Guys, Anyone any good with Office Scripts? I want to add a 'Clear' button to the Excel web version. Tried using similar script to the normal VBA but doesn't work. If anyone knows what the Offi...
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.
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,
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.
