title: How to get specific Range in Excel through COM Interop?
body: <p>I have to read an excel file through a COM interop. I search for a specific string using this:</p>
  <pre><code>this.sheet = (Excel.Worksheet)this.excelApp.Workbook.Sheets.Item[this.sheetname];
              this.sheet.Activate();
              Excel.Range firstRow = this.sheet.Range[&quot;A1&quot;, &quot;XFD1&quot;];
              Excel.Range foundRange = firstRow.Find(
                  this.StringISearch,
                  Type.Missing,
                  Type.Missing,
                  Excel.XlLookAt.xlWhole,
                  Excel.XlSearchOrder.xlByColumns,
                  Excel.XlSearchDirection.xlNext,
                  false,
                  false,
                  Type.Missing);
  </code></pre>
  <p>Now I want to use the foundRange as a starting point to get another range.</p>
  <p>Something like this</p>
  <pre><code>Excel.Range MyRange = this.sheet.Range[foundRange + 2 rows, + 1 column &amp; lastRow];
  </code></pre>
  <p>I don't see a way to do this. Is there one?</p>