# GrapeCity.Spreadsheet.IRange.Find

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Spreadsheet_IRange_Find_" data-uid="GrapeCity.Spreadsheet.IRange.Find*">Find Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Spreadsheet_IRange_Find_" data-uid="GrapeCity.Spreadsheet.IRange.Find*"></a>
<h4 id="GrapeCity_Spreadsheet_IRange_Find_System_Object_System_Object_GrapeCity_Spreadsheet_FindLookIn_GrapeCity_Spreadsheet_LookAt_GrapeCity_Spreadsheet_SearchOrder_GrapeCity_Spreadsheet_SearchDirection_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IRange.Find(System.Object,System.Object,GrapeCity.Spreadsheet.FindLookIn,GrapeCity.Spreadsheet.LookAt,GrapeCity.Spreadsheet.SearchOrder,GrapeCity.Spreadsheet.SearchDirection,System.Boolean)">Find(object, object, FindLookIn, LookAt, SearchOrder, SearchDirection, bool)</h4>
<div class="markdown level1 summary"><p>Finds specific information in a range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">IRange Find(object what, object after = null, FindLookIn lookIn = FindLookIn.Values, LookAt lookAt = LookAt.Part, SearchOrder searchOrder = SearchOrder.Rows, SearchDirection searchDirection = SearchDirection.Next, bool matchCase = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function Find(what As Object, Optional after As Object = Nothing, Optional lookIn As FindLookIn = FindLookIn.Values, Optional lookAt As LookAt = LookAt.Part, Optional searchOrder As SearchOrder = SearchOrder.Rows, Optional searchDirection As SearchDirection = SearchDirection.Next, Optional matchCase As Boolean = False) As IRange</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></td>
      <td><span class="parametername">what</span></td>
      <td><p>The data to search for.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></td>
      <td><span class="parametername">after</span></td>
      <td><p>The cell after which you want the search to begin. The search begins after this cell; the specified cell isn't searched until the method wraps back around to this cell. If you do not specify this argument, the search starts after the cell in the upper-left corner of the range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.FindLookIn.html">FindLookIn</a></td>
      <td><span class="parametername">lookIn</span></td>
      <td><p>The type of data to search.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.LookAt.html">LookAt</a></td>
      <td><span class="parametername">lookAt</span></td>
      <td><p>A <a class="xref" href="GrapeCity.Spreadsheet.LookAt.html">LookAt</a> value indicates whether a match is made against the whole of the search text or any part of the search text.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.SearchOrder.html">SearchOrder</a></td>
      <td><span class="parametername">searchOrder</span></td>
      <td><p>The order in which to search the range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.SearchDirection.html">SearchDirection</a></td>
      <td><span class="parametername">searchDirection</span></td>
      <td><p>A <a class="xref" href="GrapeCity.Spreadsheet.SearchDirection.html">SearchDirection</a> value indicates whether a match is made against the whole of the search text or any part of the search text.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">matchCase</span></td>
      <td><p><code>true</code> to make the search case-sensitive.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents the first cell where that information is found.</p>
</td>
    </tr>
  </tbody>
</table>
</div>