# C1.WPF.Excel.XLCellRangeCollection.Insert

## Content

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



<h1 id="C1_WPF_Excel_XLCellRangeCollection_Insert_" data-uid="C1.WPF.Excel.XLCellRangeCollection.Insert*">Insert Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_WPF_Excel_XLCellRangeCollection_Insert_" data-uid="C1.WPF.Excel.XLCellRangeCollection.Insert*"></a>
<h4 id="C1_WPF_Excel_XLCellRangeCollection_Insert_System_Int32_C1_WPF_Excel_XLCellRange_" data-uid="C1.WPF.Excel.XLCellRangeCollection.Insert(System.Int32,C1.WPF.Excel.XLCellRange)">Insert(int, XLCellRange)</h4>
<div class="markdown level1 summary"><p>Inserts an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object at a specific position in 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 Insert(int index, XLCellRange cr)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Insert(index As Integer, 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="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">index</span></td>
      <td><p>Position where the object will be inserted.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a></td>
      <td><span class="parametername">cr</span></td>
      <td><p>Object to insert in 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.WPF.Excel.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>