# GrapeCity.Documents.Excel.IWorksheet.AutoMerge

## Content

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



<h1 id="GrapeCity_Documents_Excel_IWorksheet_AutoMerge_" data-uid="GrapeCity.Documents.Excel.IWorksheet.AutoMerge*">AutoMerge Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IWorksheet_AutoMerge_" data-uid="GrapeCity.Documents.Excel.IWorksheet.AutoMerge*"></a>
<h4 id="GrapeCity_Documents_Excel_IWorksheet_AutoMerge_GrapeCity_Documents_Excel_IRange_GrapeCity_Documents_Excel_AutoMergeDirection_GrapeCity_Documents_Excel_AutoMergeMode_GrapeCity_Documents_Excel_AutoMergeSelectionMode_" data-uid="GrapeCity.Documents.Excel.IWorksheet.AutoMerge(GrapeCity.Documents.Excel.IRange,GrapeCity.Documents.Excel.AutoMergeDirection,GrapeCity.Documents.Excel.AutoMergeMode,GrapeCity.Documents.Excel.AutoMergeSelectionMode)">AutoMerge(IRange, AutoMergeDirection, AutoMergeMode, AutoMergeSelectionMode)</h4>
<div class="markdown level1 summary"><p>Applies auto merge for a range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">void AutoMerge(IRange range, AutoMergeDirection direction = AutoMergeDirection.Column, AutoMergeMode mode = AutoMergeMode.Free, AutoMergeSelectionMode selectionMode = AutoMergeSelectionMode.Source)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Sub AutoMerge(range As IRange, Optional direction As AutoMergeDirection = AutoMergeDirection.Column, Optional mode As AutoMergeMode = AutoMergeMode.Free, Optional selectionMode As AutoMergeSelectionMode = AutoMergeSelectionMode.Source)</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.IRange.html">IRange</a></td>
      <td><span class="parametername">range</span></td>
      <td><p>The auto merge range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.AutoMergeDirection.html">AutoMergeDirection</a></td>
      <td><span class="parametername">direction</span></td>
      <td><p>The auto merge direction. The default value is <a class="xref" href="GrapeCity.Documents.Excel.AutoMergeDirection.html#GrapeCity_Documents_Excel_AutoMergeDirection_Column">Column</a>. Specially, if the direction is <a class="xref" href="GrapeCity.Documents.Excel.AutoMergeDirection.html#GrapeCity_Documents_Excel_AutoMergeDirection_None">None</a>, the auto merge for the range will be canceled.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.AutoMergeMode.html">AutoMergeMode</a></td>
      <td><span class="parametername">mode</span></td>
      <td><p>The auto merge mode. The default value is <a class="xref" href="GrapeCity.Documents.Excel.AutoMergeMode.html#GrapeCity_Documents_Excel_AutoMergeMode_Free">Free</a>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.AutoMergeSelectionMode.html">AutoMergeSelectionMode</a></td>
      <td><span class="parametername">selectionMode</span></td>
      <td><p>The auto merge selection mode. The default value is <a class="xref" href="GrapeCity.Documents.Excel.AutoMergeSelectionMode.html#GrapeCity_Documents_Excel_AutoMergeSelectionMode_Source">Source</a>.</p>
</td>
    </tr>
  </tbody>
</table>
</div>