# GrapeCity.Documents.Excel.IRange.SpecialCells

## Content

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



<h1 id="GrapeCity_Documents_Excel_IRange_SpecialCells_" data-uid="GrapeCity.Documents.Excel.IRange.SpecialCells*">SpecialCells Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IRange_SpecialCells_" data-uid="GrapeCity.Documents.Excel.IRange.SpecialCells*"></a>
<h4 id="GrapeCity_Documents_Excel_IRange_SpecialCells_GrapeCity_Documents_Excel_SpecialCellType_System_Nullable_GrapeCity_Documents_Excel_SpecialCellsValue__" data-uid="GrapeCity.Documents.Excel.IRange.SpecialCells(GrapeCity.Documents.Excel.SpecialCellType,System.Nullable{GrapeCity.Documents.Excel.SpecialCellsValue})">SpecialCells(SpecialCellType, SpecialCellsValue?)</h4>
<div class="markdown level1 summary"><p>Gets a <a class="xref" href="GrapeCity.Documents.Excel.IRange.html">IRange</a> object that represents all
the cells that match the specified type and value.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">IRange SpecialCells(SpecialCellType type, SpecialCellsValue? value = null)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SpecialCells(type As SpecialCellType, Optional value As SpecialCellsValue? = Nothing) 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="GrapeCity.Documents.Excel.SpecialCellType.html">SpecialCellType</a></td>
      <td><span class="parametername">type</span></td>
      <td><p>The cells to include.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.SpecialCellsValue.html">SpecialCellsValue</a>?</td>
      <td><span class="parametername">value</span></td>
      <td><p>If Type is either <a class="xref" href="GrapeCity.Documents.Excel.SpecialCellType.html#GrapeCity_Documents_Excel_SpecialCellType_Constants">Constants</a> or
<a class="xref" href="GrapeCity.Documents.Excel.SpecialCellType.html#GrapeCity_Documents_Excel_SpecialCellType_Formulas">Formulas</a>, this argument is used to
determine which types of cells to include in the result.
These values can be added together to return more than one type.
The default is to select all constants or formulas,
no matter what the type.</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.Documents.Excel.IRange.html">IRange</a></td>
      <td><p>Returns a <a class="xref" href="GrapeCity.Documents.Excel.IRange.html">IRange</a> object that represents all
the cells that match the specified type and value.</p>
</td>
    </tr>
  </tbody>
</table>
</div>