title: Set cell contents to sheet name
body: <p>Simple question for you experts out there.</p>
  
  <p>Trying to figure out how to have cell A1 = sheetname.</p>
  
  <p>I tried the following but got a compile error</p>
  
  <pre><code>y = Sheetname()
  
  Range(A1) = y
  </code></pre>