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

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace