Next Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

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