title: Clear cells across two or more sheets
body: <p>I have the following simple script which deletes a range of cells from one sheet. How can I amend this so that I can specify cells across more than one sheet? I assume it's something to do with changing getSheetByName? Many thanks.</p>
  
  <pre><code>function clearandover() {
    //replace 'Sheet1' with your actual sheet name
    var sheet = SpreadsheetApp.getActive().getSheetByName('Andover');
    sheet.getRange('B8:G').clearContent();
  }
  </code></pre>