Skip to main content

Range.ID property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Returns or sets a String value that represents the identifying label for the specified cell when the page is saved as a webpage.

Syntax

expression.ID

expression A variable that represents a Range object.

Remarks

Use an ID label as a hyperlink reference in other HTML documents or on the same webpage.

Example

This example sets the ID of cell A1 on the active worksheet to Target.

ActiveSheet.Range("A1").ID = "target"

Later, the document is saved as a webpage, and the following line of HTML is added to the webpage. When the user then views the page in a web browser and chooses the hyperlink, the browser displays the cell.

<a href="#target">Quarterly earnings</a>

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>