Range.Next Property

Excel Developer Reference

Returns a Range object that represents the next cell.

Syntax

expression.Next

expression   A variable that represents a Range object.

Remarks

If the object is a range, 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.

See Also