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 Jim_Currier__NPL ,
Actually, it has a syntax of a VBA code, but I see that there is an error in that, apparently.
If you want to clear the whole range between rows 2 and 8 in column C, you may use this code:
Sub Clearcells()
'Updateby Extendoffice
Range("C2:C8").ClearContents
End Sub
If you want to clear ONLY the cells C2 and C8, you may use this code:
Sub Clearcells()
'Updateby Extendoffice
Range("C2").ClearContents
Range("C8").ClearContents
End Sub
Let me know if it works for you.