title: Excel visual basic 1004 error, method 'value' of object 'range' failed
body: <p>I made a little add-in for excel.
  But for some reason it fails. After a fresh startup of excel it works fine, however when I copy paste text into excel and try to run it, it gives me the error: run-time '1004' , method 'Value' of object 'range' failed.</p>
  
  <p>What I'm trying to do, is quit simple. I like building formula's like : (B5+B6)/2 without the use of an '=' in front so Excel doesn't calculate these expressions. I end up with one big column, and after I am finished I would like to select the first cell of the column with calculations, activate my add-in and he puts an '=' in front and loops downward untill an empty cell. This way each cell in my column is now calculated.</p>
  
  <p>I am lost, can you help me ?</p>
  
  <pre><code>Sub makeFormula()
  Do
  ActiveCell.Value = "=" &amp; ActiveCell.Value
  ActiveCell.Offset(1, 0).Select
  Loop While ActiveCell.Value &lt;&gt; Empty
  end Sub
  </code></pre>