title: Getting Error: HRESULT: 0x800A03EC while manipilating Excel in c#
body: <p>I am getting an error:
  Exception from HRESULT: 0x800A03EC
  whenever I set the formula for the range as:</p>
  
  <pre><code>        Range range = destinationSheet.Range["A1"];
          string[,] formulaString = new string[numberOfRows, 1];
          range = range.Resize[numberOfRows, 1];
  
          for (int count = 1; count &lt;= numberOfRows; count++)
          {
              string worksheet = "Sheet1";
              string cellRef = "A1"
              string formula = string.Format("={0}!{1}", sourceSheetName, cellRef);
              formulaString[count-1, 0] = formula;                
          }
  
          range.set_Value(Type.Missing, formulaString); 
          range.Formula = range.Value;   // getting exception here
  </code></pre>
  
  <p>what might be the reason for this</p>