NamedRange.Next Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets a Range that represents the next cell.

public:
 property Microsoft::Office::Interop::Excel::Range ^ Next { Microsoft::Office::Interop::Excel::Range ^ get(); };

public Microsoft.Office.Interop.Excel.Range Next { get; }

member this.Next : Microsoft.Office.Interop.Excel.Range

Public ReadOnly Property Next As Range

Property Value

Range

A Range that represents the next 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.

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

    this.nextCellRange.Next.Select();
}

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

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.

Applies to

Share via