Next Property

Next property as it applies to the Range object.

Returns a Range object that represents the next cell. This property emulates pressing TAB; unlike the keystroke, the property returns the previous 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.

expression.Next

*expression   * Required. An expression that returns a Range object.

Next property as it applies to the Worksheet object.

Returns a Worksheet object that represents the next sheet.

expression.Next

*expression   * Required. An expression that returns a Worksheet object.

Example

As it applies to the Range object.

This example selects the next unlocked cell on the active worksheet. If the active worksheet is unprotected, this is the cell immediately to the right of the active cell.

Spreadsheet1.ActiveCell.Next.Select

Applies to | Range Object | Worksheet Object

See Also | Previous Property