title: How to call a macro from another macro in google sheets?
body: <p>In google sheets, I have a macro that runs until an IFS statement wants to call another macro when true, but I get an error message instead.</p>
  
  <pre><code>spreadsheet.getCurrentCell().offset(0, 0, 48, 4).activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getActiveRange().If Range('B2').value = 10, Then Call Ten;  
  </code></pre>
  
  <p>I expected the macro named Ten to run, and then return to run the final 2 rows of code (not shown).</p>
  
  <p>Error message:</p>
  
  <blockquote>
    <p>Missing ; before statement. (line 16, file "macros")Dismiss</p>
  </blockquote>