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
- 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.