title: Row count after applying AutoFilter in Excel
body: <p>I am using the below piece of code to get the Row Count from an Excel file after applying AutoFilter method. But it always returns me 1 as Row count. Please help</p>
  
  <pre><code>Excel.Range rngFilter = (Excel.Range)applicationObject.get_Range("Staffing", Type.Missing);
  rngFilter.AutoFilter(1, "Transition", XlAutoFilterOperator.xlAnd, Type.Missing, true);
  Excel.Range rngResult = rngFilter.SpecialCells(XlCellType.xlCellTypeVisible, Type.Missing);
  MessageBox.Show(rngResult.Rows.Count.ToString());
  </code></pre>