Range.ID Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .ID

expression A variable that represents a Range object.

You can use an ID label as a hyperlink reference in other HTML documents or on the same Web page.

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 Web page, and the following line of HTML is added to the Web page. When the user then views the page in a Web browser and clicks the hyperlink, the browser displays the cell.

<A HREF="#target">Quarterly earnings</A>

Concepts

Other resources

Show: