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