title: Getting "HRESULT: 0x800A01A8" error while hiding rows using vsto on vs2005
body: <p>I am attempting to hide some rows in an excel sheet using C#.</p>
  
  <p>but the line </p>
  
  <pre><code>deleteRange.EntireRow.Hidden = true;
  </code></pre>
  
  <p>is giving errors.</p>
  
  <p>The entire code of selecting the range and hiding the rows is given below</p>
  
  <pre><code>string rowCnt = Convert.ToString(excelExportData.Tables["AllVersionDts"].Rows.Count + 8);
  string startCell = "A" + rowCnt;
  Microsoft.Office.Interop.Excel.Range deleteRange = ws.get_Range(startCell+":A65536",Missing.Value);
  deleteRange.EntireRow.Delete(Microsoft.Office.Interop.Excel.XlDeleteShiftDirection.xlShiftUp);
  
  deleteRange.EntireRow.Hidden = true;
  </code></pre>
  
  <p>Please look into this code and say where am I going wrong.</p>
  
  <p>Thanks</p>