Share via


NamedRange.InsertIndent Method

Adds an indent to the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Sub InsertIndent ( _
    InsertAmount As Integer _
)
void InsertIndent(
    int InsertAmount
)

Parameters

  • InsertAmount
    Type: System.Int32

    The amount to be added to the current indent.

Remarks

Using this method to set the indent level to a number less than 0 (zero) or greater than 15 causes an exception to be thrown.

Use theIndentLevel property to return the indent level for a range.

Examples

The following code example creates a NamedRange and then uses the InsertIndent method to set an indent level for the NamedRange.

This example is for a document-level customization.

Private addIndentRange As Microsoft.Office.Tools.Excel.NamedRange

Private Sub AddIndent()
    addIndentRange = Me.Controls.AddNamedRange( _
        Me.Range("B4"), "addIndentRange")
    Me.addIndentRange.Value2 = "Smith" 
    Me.addIndentRange.InsertIndent(2)
End Sub
Microsoft.Office.Tools.Excel.NamedRange addIndentRange;
private void AddIndent()
{
    addIndentRange = this.Controls.AddNamedRange(
        this.Range["B4"], "addIndentRange");
    this.addIndentRange.Value2 = "Smith";
    this.addIndentRange.InsertIndent(2);
}

.NET Framework Security

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace