# GrapeCity.Spreadsheet.IRange.SpecialCells

## Content

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



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



<a id="GrapeCity_Spreadsheet_IRange_SpecialCells_" data-uid="GrapeCity.Spreadsheet.IRange.SpecialCells*"></a>
<h4 id="GrapeCity_Spreadsheet_IRange_SpecialCells_GrapeCity_Spreadsheet_SpecialCellType_GrapeCity_Spreadsheet_SpecialCellsValue_" data-uid="GrapeCity.Spreadsheet.IRange.SpecialCells(GrapeCity.Spreadsheet.SpecialCellType,GrapeCity.Spreadsheet.SpecialCellsValue)">SpecialCells(SpecialCellType, SpecialCellsValue)</h4>
<div class="markdown level1 summary"><p>Gets a <a class="xref" href="GrapeCity.Spreadsheet.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 = SpecialCellsValue.All)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SpecialCells(type As SpecialCellType, Optional value As SpecialCellsValue = SpecialCellsValue.All) 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.Spreadsheet.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.Spreadsheet.SpecialCellsValue.html">SpecialCellsValue</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>If <code class="paramref">type</code> is either <a class="xref" href="GrapeCity.Spreadsheet.SpecialCellType.html#GrapeCity_Spreadsheet_SpecialCellType_Constants">Constants</a> or <a class="xref" href="GrapeCity.Spreadsheet.SpecialCellType.html#GrapeCity_Spreadsheet_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.Spreadsheet.IRange.html">IRange</a></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents all the cells that match the specified type and value</p>
</td>
    </tr>
  </tbody>
</table>
</div>