# C1.C1Excel.XLCellRangeCollection.Add

## Content

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



<h1 id="C1_C1Excel_XLCellRangeCollection_Add_" data-uid="C1.C1Excel.XLCellRangeCollection.Add*">Add Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_C1Excel_XLCellRangeCollection_Add_" data-uid="C1.C1Excel.XLCellRangeCollection.Add*"></a>
<h4 id="C1_C1Excel_XLCellRangeCollection_Add_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.Add(C1.C1Excel.XLCellRange)">Add(XLCellRange)</h4>
<div class="markdown level1 summary"><p>Appends an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object to the collection.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public XLCellRange Add(XLCellRange cr)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Add(cr As XLCellRange) As XLCellRange</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="C1.C1Excel.XLCellRange.html">XLCellRange</a></td>
      <td><span class="parametername">cr</span></td>
      <td><p><a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object to add to the collection.</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="C1.C1Excel.XLCellRange.html">XLCellRange</a></td>
      <td><p>A reference to the object if it was successfully added to the collection,
or null if the object could not be added to the collection (usually because it
overlaps another cell range already in the collection).</p>
</td>
    </tr>
  </tbody>
</table>


<a id="C1_C1Excel_XLCellRangeCollection_Add_" data-uid="C1.C1Excel.XLCellRangeCollection.Add*"></a>
<h4 id="C1_C1Excel_XLCellRangeCollection_Add_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="C1.C1Excel.XLCellRangeCollection.Add(System.Int32,System.Int32,System.Int32,System.Int32)">Add(int, int, int, int)</h4>
<div class="markdown level1 summary"><p>Creates an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object and appends it to the collection.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public XLCellRange Add(int rowIndex, int colIndex, int rowCount, int colCount)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Add(rowIndex As Integer, colIndex As Integer, rowCount As Integer, colCount As Integer) As XLCellRange</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.int32">int</a></td>
      <td><span class="parametername">rowIndex</span></td>
      <td><p>Index of the top row in the cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">colIndex</span></td>
      <td><p>Index of the left column in the cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">rowCount</span></td>
      <td><p>Number of rows in the cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">colCount</span></td>
      <td><p>Number of columns in the cell range.</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="C1.C1Excel.XLCellRange.html">XLCellRange</a></td>
      <td><p>A reference to the object if it was successfully added to the collection,
or null if the object could not be added to the collection (usually because it
overlaps another cell range already in the collection).</p>
</td>
    </tr>
  </tbody>
</table>
</div>