Expand Minimize

Range.ID Property (Excel)

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:
© 2015 Microsoft