Udostępnij za pośrednictwem


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

See Also

Reference

NamedRange Class

NamedRange Members

Microsoft.Office.Tools.Excel Namespace