title: Concatenate cells from multiple sheets in Excel
body: <p>I’m trying to use <a href="https://stackoverflow.com/questions/8135995/how-to-merge-all-column-into-one-cell-in-excel">How to merge rows in a column into one cell in excel?</a> to make </p>
  
  <pre><code>=ConcatenateRange(sheet1:sheet2!B1,",")
  </code></pre>
  
  <p>but it doesn't seem to work. What comes back from <code>sheet1:sheet2!B1</code>? Is it a range, or something else?</p>