title: Excel enter formula into cell
body: <pre><code>Function bd()
  
      Sheets("sheet1").Range("A1").value=1
  
  End Function
  </code></pre>
  
  <p>This is my function. 
  Why is it that when i enter <code>=bd()</code> into any cell in sheet1, the data in A1 does not change to 1? I do not want to use the button to change the value.</p>