Share via


NamedRange.Next Property

Gets a Microsoft.Office.Interop.Excel.Range that represents the next cell.

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

Syntax

'Declaration
ReadOnly Property Next As Range
    Get
Range Next { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range
A Microsoft.Office.Interop.Excel.Range that represents the next cell.

Remarks

This property emulates the TAB key, although the property returns the next cell without selecting it.

On a protected sheet, this property returns the next unlocked cell. On an unprotected sheet, this property always returns the cell immediately to the right of the specified cell.

Examples

The following code example creates a NamedRange and then uses the Next property to select the cell to the right of the NamedRange.

This example is for a document-level customization.

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

Private Sub SelectNext()
    nextCellRange = Me.Controls.AddNamedRange( _
        Me.Range("C1"), "nextCellRange")

    Me.nextCellRange.Next.Select()
End Sub
Microsoft.Office.Tools.Excel.NamedRange nextCellRange;
private void SelectNext()
{
     nextCellRange = this.Controls.AddNamedRange(
         this.Range["C1", missing], "nextCellRange");

    this.nextCellRange.Next.Select();
}

.NET Framework Security

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace