NamedRange.Next Property (2007 System)
Gets a Range that represents the next cell.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Next As Range
'Usage
Dim instance As NamedRange
Dim value As Range
value = instance.Next
[BrowsableAttribute(false)]
public Range Next { get; }
[BrowsableAttribute(false)]
public:
property Range^ Next {
Range^ get ();
}
public function get Next () : Range
Property Value
Type: Range
A 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.