title: Google Script: set cell value + prompt message box
body: <p>I'm working on the script below (keep in mind that it's far from done):</p>
  
  <pre><code>function Import() {
    var dealCells = getRange('Deals');
  
    var blank = new Array ("");  
  
    if (blank.indexOf(dealCells.getValue()) != -1) {
      if (Browser.msgBox('You have not entered all the Deal IDs, do you want to continue anyway?', Browser.Buttons.YES_NO) == 'no') {
        Browser.msgBox('Please fill in all the Deal IDs')
  
        if (blank.indexOf(dealCells.getValue()) == -1) {
          var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Worksheet");
          var cell = sheet.getRange(2,12);
          cell.setValue("IMPORT");
        }
      }
    }
  }
  </code></pre>
  
  <p>I'm trying to determine whether or not there is an empty cell in the range A4:A23 in the worksheet 'Newsletter'.</p>
  
  <ul>
  <li><p><strong>If there is an empty cell:</strong> prompt the yes/no message box</p>
  
  <ul>
  <li><strong>If yes:</strong> continue with setting the cell value to 'IMPORT' and finish the script without further actions</li>
  <li><strong>If no:</strong> prompt the second message box and finish the script without any further action</li>
  </ul></li>
  </ul>