Google Sheets Script - Reset Button Clear cells in multiple sheets

[Jess K]

Hi,

I found a form with info on creating reset buttons. Alex Ivanov offered a script for clearing cells in multiple worksheets,  but I'm trying to use it and it's not working. Can anyone help?

This is what I need cleared:

Sheet 1 B7:D100

Sheet 2 Column H through K

This is the script Alex originally posted. 

function onOpen() {
  SpreadsheetApp.getUi()
  .createMenu('Reset sheet')
  .addItem('Based on a permanent ranges address list', 'userActionResetByRangesAddresses')
  .addToUi();
}

function userActionResetByRangesAddresses(){
  var sheet = SpreadsheetApp.getActiveSheet();
  var rangesAddressesList = ['B5', 'B7', 'B9', 'B11', 'B15', 'B19'];
  resetByRangesList_(sheet, rangesAddressesList);
}

function resetByRangesList_(sheet, rangesAddressesList){
  sheet.getRangeList(rangesAddressesList).clearContent();
}

I tried it and changed the values, but kept getting an error when running it.

Let me know if you can help.

Thanks,

Jess

[Tanaike]

In your situation, for example, are these sample scripts useful?

https://tanaikech.github.io/2022/08/08/clearing-discrete-cell-values-on-multiple-sheets-using-google-apps-script/

[game over]

https://fabform.io/a/how-to-find-google-sheet-id