Skip to main content

Range.Next property

Table of contents
  1. Syntax
  2. Remarks

Returns a Range object that represents the next cell.



expression A variable that represents a Range object.


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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>